MySQL Import Export data

Mysqldump is a MySQL-brought export data tool that we usually use to export MySQL, but sometimes we need to export some of the data from a table in the MySQL database as a test.

The mysqldump command has a--where/-w parameter, which is used to set the condition of the data export, in the same way as in the SQL Query command, where the command format is as follows:

Export structure export part of data

Mysqldump-u User name-p password database name table name--where= "filter Condition" > Export file path mysqldump  -h54.0.88.53-uroot-ppassword Chen  canal_amt1- -where = sensorid=11 and fieldid=0 >/home/kang/desktop/temp/test.sqlmysqldump-uroot-p123456 kang organ--where paren tid=1 >/home/kang/desktop/temp/organ2.sqlmysqldump-uroot-p123456 kang organ--where= "parentid=1"  >/home/ kang/desktop/temp/organ2.sqlmysqldump-uroot-p123456 Kang organ--where= "1=1 limit 5" >/home/kang/desktop/temp/ organ2.sqlmysqldump-uroot-p123456 Kang organ--where= "true limit 5" >/home/kang/desktop/temp/organ2.sql import: Use Database;source/home/kang/desktop/temp/organ2.sql;

Export Top n records for all tables in a database

mysqldump-uroot-p123456 kang--where= "1=1 limit 5" >/home/kang/desktop/temp/organ2.sql

Mysqldump can include additional parameters:

Backup database #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. SQL1. Export structure does not export data mysqldump-d database name-uroot-p > Xxx.sqlmysqldump-h localhost-uroot-p123456-  D table > du MP.SQL2. Export data does not export structure MYSQLDUMP-T database name-uroot-p > xxx.sql3. Export data and table structure mysqldump database name-uroot-p > Xxx.sqlmysqldump-h Local host-uroot-p123456  database table > Dump.sql

　　

　

MySQL Import Export data