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

Steve32

Premium Member
Premium
Registered
Joined
Mar 15, 2014
Messages
111
Points
18
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

Well-known member
Registered
Joined
Apr 3, 2015
Messages
1,027
Points
83
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
Registered
Joined
Jan 13, 2015
Messages
866
Points
0
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 - duplicator 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

Well-known member
Registered
Joined
Nov 11, 2014
Messages
433
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
Registered
Joined
Jul 31, 2015
Messages
16
Points
0
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
Replies
2
Views
2,029
Replies
4
Views
3,157
Replies
2
Views
2,341
Newer Threads
Replies
5
Views
2,780
Recommended Threads

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

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