To export a database or its individual tables, do the following:
mysqldump -h host -u login -p name_бд > way/to/catalog/dump.sql
In a team:
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:
host
, login
and name_бд
use appropriate connection data to the database from where the tables are exported.Table 1
, table 2
, table3
specify the names of the tables you want to export.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.