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

Steve32

Premium Member
Premium Member
Joined
Mar 15, 2014
Messages
111
Best answers
0
Ratings
15
Points
18
#1
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
Joined
Apr 3, 2015
Messages
1,027
Best answers
1
Ratings
419 3
Points
83
#2
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
866
Best answers
0
Ratings
661
Points
0
#3
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
Joined
Nov 11, 2014
Messages
433
Best answers
0
Ratings
126
Points
0
#4
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.
 
Joined
Jul 31, 2015
Messages
16
Best answers
0
Ratings
5
Points
0
#5
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
1,287
Replies
4
Views
1,835
Replies
2
Views
1,397
Newer Threads
Replies
5
Views
1,307
Latest Threads
Replies
2
Views
31
Replies
0
Views
34
Replies
4
Views
44
Replies
4
Views
70

Latest Hosting OffersNew Reviews

Sponsors

Latest Blog ArticlesMost Viewed Threads

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