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

[Steve32]

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, 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]

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]

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]

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.