MySQL export table structure and table data mysqldump usage

MySQL export table structure and table data mysqldump usage

The following are the specific uses of the command line:

Mysqldump-u User name-p password- d database name table name > script name;

Export the entire database structure and data
Mysqldump-h localhost-uroot-p123456 Database > Dump.sql

Export a single data table structure and data
Mysqldump-h localhost-uroot-p123456 database table > Dump.sql

Export the entire database structure (no data included)

Mysqldump-h localhost-uroot-p123456-d Database > Dump.sql

Export a single data table structure (no data included)
Mysqldump-h localhost-uroot-p123456-d database table > Dump.sql

Mysqldump Backup export data exclude a table

Just use the--ignore-table=dbname.tablename parameter on the line.

mysqldump-uusername-ppassword-h192.168.0.1-p3306 dbname--ignore-table=dbname.dbtanles > Dump.sql

MySQL export table structure and table data mysqldump usage