Is it possible to backup Mysql database without using cPanel or Phpmyadmin?

Steve32

Active member
Joined
Mar 15, 2014
Messages
210
Points
28
As title mentioned, I would like to know it is possible to backup Mysql database without using cPanel or Phpmyadmin?

there are other ways to backup databases on your hosting without using those tools?
 

RDO Servers

New member
Joined
Apr 3, 2015
Messages
770
Points
0
Well, it depends. Do you have direct database access, or are you on a shared account with only cPanel access?

You can always generate Create Statements as a backup
 

elcidofaguy

Well-known member
Joined
Jan 13, 2015
Messages
1,281
Points
113
Its pretty easy to create a database backup... For example if you are using wordpress or any other CMS then you will find a lot of plugins which can do this for you... For that my preference is to use the - [URLnf="https://wordpress.org/plugins/duplicator/"]duplicator [/URLnf]plugin...

Another way you can do that is to setup a schedule task on your server (but you will need to access cpanel to set that up as a cron job) which dumps the data to a location of your choice i.e. folder on server, dropbox etc... There are various scripts for that which you can find online and adapt for your own use... If you are having problems with setting something like that then I recommend contacting your webhost - as I am sure they will be delighted to help, offer guidance on that matter...

Finally the other approach would be to code it your self i.e. PHP script which connects to your database and dumps the data to a SQL file or format of your choice i.e. CSV, XML etc....

In all cases make sure you consider security aspects to avoid your data being accessible/stolen...
 

Hassan

New member
Joined
Nov 11, 2014
Messages
706
Points
0
You can export/import a MySQL database via SSH.

Export:
mysqldump -uUSERNAME -pPASSWORD DATABASE > file.sql

Import:
mysql -uUSERNAME -pPASSWORD DATABASE < file.sql

Note:
Change USERNAME , PASSWORD AND DATABASE with your details.
 

MarcS

Member
Joined
Jul 31, 2015
Messages
31
Points
8
When you do not have cPanel and phpMyadmin, the only way you can access the server is to have jailedshell. You can run mysqldump command to take the MySQL backups after having jailedshell access.

mysqldump -u username -p database_name > file-name.sql

Most Web Hosts provide jailedshell on demand.
 
Older threads
Newer threads

Referral contests

Referral link for :

Sponsors

Popular tags

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top