Log in to "cPanel ""phpMyAdmin "

file

Next, select the database you want to back up on the left and click the "Export " button in the top menu.
Important! If you select any one table, only that table will be backed up

file

A dialog box will open, be sure to select the SQL database type, then click OK

file

Wait for the database file to download to your computer.


It is also possible to export the database using console commands by connecting to the server through the terminal, which can be found in the Advanced section

mysqldump -uUSER -pPASSWORD DBNAME > /path/to/DUMPFILE.sql  

There is no space between flags -u, -p and their arguments (in this case USER and PASSWORD).

  • "USER " is the database user (e.g. "f37295_wp1");

  • "PASSWORD " - database user password;

  • "DBNAME " - name of the database to be exported (for example, "f37295_wp");

  • "/path/to/" - path to the directory.

  • "DUMPFILE.sql " - name of the file to save the database dump in sql format.

file