MySQL export single table data/backup single table data statement

The first two days when you encountered data recovering data with the source command, the prompt package was too big an error. That package Mymanager exported, this time with MySQL with the Mysqldump tool successfully exported and imported into the datasheet.

Mysqldump data methods for exporting a table of a database are as follows:

The code is as follows	Copy Code
MYSQLDUMP-T-U root-p-B article--table article_detail > E:/www.111cn.net/my.sql

Where article is a database, Article_detail is a datasheet (only the data is not included in the structure).
When restoring data, use the source command

The code is as follows	Copy Code
Source/db/my.sql

So if you encounter Chinese may appear garbled, we can be as follows to improve

When you export the MySQL SQL execution file, specify the encoding format:

The code is as follows	Copy Code
Mysqldump-uroot-p--default-character-set=utf8 Mo (dbname) > E://xxxx.sql

It's OK when you import it.

Perform the following

code is as follows	copy code
Mysql-u Root-p--default-character-set=utf8 Use dbname source/root/newsdata.sql