2.10.8. Database export via console

To export a database or its individual tables, do the following:

1. Connect to hosting via SSH.
2. Run the appropriate command:

   • Exporting the entire database
   • Exporting individual tables

   mysqldump -h host -u login -p name_бд > way/to/catalog/dump.sql

   In a team:

   • Instead host, login and name_бд use appropriate connection data to the exported database.
   • Instead path / to / directory / dump.sql specify the path to the file to which the dump should be saved, or just its name if the file should be in the current directory.

   mysqldump -h host -u login -p name_db table1 table2 table3 > way/to/catalog/dump.sql

   In a team:

   • Instead host, login and name_бд use appropriate connection data to the database from where the tables are exported.
   • Instead Table 1, table 2, table3 specify the names of the tables you want to export.
   • Instead path / to / directory / dump.sql specify the path to the file to which the dump should be saved, or just its name if the file should be in the current directory.
3. Enter the password of the database user from connection data.

   Attention! For security reasons, in Linux systems, when entering a password or pasting it from the clipboard, characters are not displayed on the screen.
4. Wait for the command to complete.