Creating a MySQL database backup on Virtual Hosting

Log in to "cPanel" → "phpMyAdmin"

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

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

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 via terminal, which can be found under Advanced.

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

There is no space between the -u, -p flags 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 exported database (for example "f37295_wp");

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

• "DUMPFILE.sql" - name of the file with which the database dump in sql format will be saved.