MySQL Import and export

2015-09-23

MySQL Export

1. Export the database

Mysqldump-u User name-p password Library name > library name _backup.sql

2. Export only all table structures and do not export table data

Mysqldump-u User name-p password-d library name > library name _d_backup.sql

3. Export all table data only, do not export table structure

Mysqldump-u User name-p password-T library name > Library name _t_backup.sql

4. Export the table

Mysqldump-u User name-p password Library name table name > library name. Table name _backup.sql

5. Export table structure only, do not export table data

Mysqldump-u User name-p password-d library Name table name > library name. Table name _d_backup.sql

6. Export only table data, not export table structure

Mysqldump-u User name-p password-T library name table name > library name. Table name _t_backup.sql

MySQL Import

1. Import the database

Mysql-u User name-p password Library name < library name _backup.sql

2. Import only all table structures, not import table data

Mysql-u User name-p password-d library name < library name _d_backup.sql

3. Import all table data only, do not import table structure

Mysql-u User name-p password-T library name < library name _t_backup.sql

4. Importing tables

Mysql-u User name-p password Library name table name < library name. Table name _backup.sql

5. Import only table structure, not import table data

Mysql-u User name-p password-d library Name table name < library name. Table name _d_backup.sql

6. Import only table data, not import table structure

Mysql-u User name-p password-T library name table name < library name. Table name _t_backup.sql

MySQL Import and export