How to export the database table structure and data from mysql

The specific usage of the command line is as follows: mysqldump-u with anonymous name-p password-d database table name Script Name; export the entire database structure and data mysqldump-hlocalhost-uroot-p123456databasedump. SQL export a single data table structure and data mysqldump-hlocalhost-uroot-p123456databasetabledump

The specific usage of the command line is as follows: mysqldump-u uses the slave 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 the structure and data of a single data table mysqldump-h localhost-uroot-p123456 database table dump

The command line is used as follows:

Mysqldump-u use the primary 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 the structure and data of a single data table
Mysqldump-h localhost-uroot-p123456 database table> dump. SQL

Export the entire database structure (excluding data)
Mysqldump-h localhost-uroot-p123456-d database> dump. SQL

Export a single data table structure (excluding data)
Mysqldump-h localhost-uroot-p123456-d database table> dump. SQL