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.

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.

---