2.11.5. Export database via console

The size of a database dump can be significantly smaller than the size of the hosted database.
  1. Connect to hosting via SSH.
  2. Run the appropriate command:
    mysqldump -h host -u login -p название_бд > way/to/catalog/dump.sql

    In a team:

    • Instead host, login and название_бд use appropriate connection data to the exported database.
    • Instead path/to/directory/dump.sql specify the path to the file where the dump should be saved, or just its name if the file should be in the current directory.
    mysqldump -h host -u login -p название_db table1 table2 table3 > way/to/catalog/dump.sql

    In a team:

    • Instead host, login and название_бд use appropriate connection data to the database from where the tables are exported.
    • Instead Table1, table2, table3 specify the names of the tables to be exported.
    • Instead path/to/directory/dump.sql specify the path to the file where 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.
Content