MySQL Database Import Export

MySQL Database Import Export:

. sql file Import MySQL:

If the database file you want to import is located at: D:test.sql.

1, enter the MySQL command line window

2, if the Test.sql file contains a create databasexxx; Statement, the command is as follows: Mysql>source D:/test.sql;

If the Test.sql file does not contain the Create DATABASEXXX statement, then there are two ways:

There is a database in the 1:mysql, such as test,

then:mysql> use test;

Mysql>source D:/test.sql;

2: Import Test.sql into a new database,

Then: 1:mysql>create database test;

Mysql>source D:/test.sql;

Note: The file path should be backslash "/"

MySQL database export available phpMyAdmin tools, you can also use this tool to implement import, very convenient