We use cookies
We use cookies to optimize our website. By continuing to browse the site, you agree to our use of cookies.
Control panel
  • Русский
  • Українська
  • English
  • UAH
  • USD
  • RUB
  • EUR
  • 0-800-307-307 Hotline
  • +38 (044) 392-74-33 Kiev
  • +38 (057) 728-39-00 Kharkiv
  • +38 (056) 794-38-31 Dnipro
  • +38 (032) 229-58-93 Lviv
  • +38 (048) 738-57-70 Odessa
  • +38(093) 170-15-42  Life
  • +38 (067) 400-88-44 Kievstar
  • +1(888)393-24-51  USA, Toll free
  • +44(131)507-01-14  Great Britain
  • +7 (499) 348-28-61 Moscow

2.10.8. Database export via console

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

  1. Run the appropriate command:
    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.
  2. Enter the password of the database user from connection data.
  3. Wait for the command to complete.