MySQL database import and Export

One, SQL file Import Database

1.mysql-u User name-p password

2.use database name; If not, build one first.

3.source d:\ file name. sql; The file path.

4.repair table name, table name, ...; The table can be repaired to prevent errors in the table.

5.check table name, table name, ...; Check all tables, is not OK.

Second, the TXT file into the table

1.mysql-u user name-p password  

2.use database name;

3.create table if not EXISTS name (field ...); Create a table first

4.load Data local infile "d:\ filename. txt" into table name; File path

5.repair table name;

6. Check table name;

Third, database export/backup

1.mysqldump-u User name-p password database name > d:\ filename. sql//sql file path

This article is from the "high-anti-server sales, bring operation and maintenance" blog, please be sure to keep this source http://kenvik.blog.51cto.com/11000054/1858441

MySQL database import and Export