2.11.5. Export database using console

To export a database or tables, do the following:

1. Connect to the hosting via SSH.
2. Export data:

   • Database
   • Tables

   mysqldump -h DB_HOST -u DB_LOGIN -p DB_NAME > PATH/TO/DUMP.SQL

   In the command, use your own data:

   • DB_HOST, DB_LOGIN, DB_NAME — data for connecting to the database, from where the export is performed.
   • PATH/TO/DUMP.SQL — path to the SQL file where the dump should be saved (or its name if the file is in the current directory).

   mysqldump -h DB_HOST -u DB_LOGIN -p DB_NAME TABLE1 TABLE2 TABLE3 > PATH/TO/DUMP.SQL

   In the command, use your own data:

   • DB_HOST, DB_LOGIN, DB_NAME — data for connecting to the database, from where the export is performed.
   • TABLE1, TABLE2, TABLE3 — names of tables to be exported.
   • PATH/TO/DUMP.SQL — path to the SQL file where the dump should be saved (or its name if the file is in the current directory).
3. Enter database user password (for security reasons, characters are not displayed on the screen when entering the password).
4. Wait for the command to complete.