The following command-line specific usage is as follows: Mysqldump-u username-p password-D is the name of the script in the database name table;
1, export the database as DBNAME table structure (where the username is root, the password is DBPASSWD, the generated script is named Db.sql)
Mysqldump-uroot-pdbpasswd-d dbname >db.sql;
2. Export the database as dbname a table (test) structure
Mysqldump-uroot-pdbpasswd-d dbname test>db.sql;
3. Export the database to dbname all table structures and table numbers (without-D)
MYSQLDUMP-UROOT-PDBPASSWD dbname >db.sql;
4. Export the database as dbname a table (test) structure and table numbers (without-D)
MYSQLDUMP-UROOT-PDBPASSWD dbname test>db.sql; MySQL mysqldump export only table structure does not export data
Copy CodeThe code is as follows:
Mysqldump--opt-d database name-u root-p > Xxx.sql
backing up the database
Copy CodeThe code is as follows:
#mysqldump database name > Database backup Name
#mysqldump-A-u user name-p password database name > database backup Name
#mysqldump-D-A--add-drop-table-uroot-p >xxx.sql
1. Export structure does not export data
Copy CodeThe code is as follows:
Mysqldump--opt-d database name-u root-p > Xxx.sql
2. Export data does not export structure
Copy CodeThe code is as follows:
MYSQLDUMP-T database name-uroot-p > Xxx.sql
3. Export Data and table structure
Copy CodeThe code is as follows:
Mysqldump database name-uroot-p > Xxx.sql
4. Export the structure of a specific table
Copy CodeThe code is as follows:
Mysqldump-uroot-p-B database name--table table name > Xxx.sql
Import Data:
Since mysqldump exports a complete SQL statement, it is easy to import the data using the MySQL client program:
Copy CodeThe code is as follows:
#mysql Database name < file name
#source/tmp/xxx.sql articles you may be interested in: