mysqldump command Export Data usage detailed

The mysqldump command comes with a--where/-w parameter that sets the conditions for the data to be exported, in the same way as the Where in the SQL query command, so that we can export the part of the data you need from the database.

1. The command format is as follows:

Mysqldump-u User name-p password database Name table name--where= Filter criteria > Export file path

Example:

Export the data with ID greater than 100 from the Test_data table in the test database to/tmp/test.sql this file

The code is as follows	Copy Code
mysqldump-uroot-p123456 test test_data--where= "ID > MB" >/tmp/test.sql

2. Export the entire database

Mysqldump-u user name-p database name > exported file name

The code is as follows	Copy Code
Mysqldump-u wcnc-p SMGP_APPS_WCNC > Wcnc.sql

3. Export a database structure

The code is as follows	Copy Code
Mysqldump-u Wcnc-p-D--add-drop-table SMGP_APPS_WCNC >d:wcnc_db.sql -D No data--add-drop-table add a drop table before each CREATE statement

Export a library table (mysqldump) condition

Mysqldump-u Username-p password-H host database a-w "SQL condition" –lock-all-tables > Path

code is as follows	copy code
1 mysqldump -hhostname-uusername-p dbname Tbname>xxxx.sql * * Exports the contents of the database table by specified criteria. (-w option –where) 1 mysqldump-hhostname-uusername-p dbname tbname-w ' ID >= 1 and id<= 10000 '--skip-lock-tables > Xxxx.sql or 1 mysqldump-hhostname-uusername-p dbname tbname--where= ' unit_id >= 1 and unit_id <= ' > 10000. SQL