MySQL Import data command

Transferred from: http://blog.sina.com.cn/s/blog_610997850100mwv8.html

Today encountered a problem to use phpMyAdmin import 1G data, but in how all can not import, with the command line is easy to fix. Use the MySQL source command to import larger files.
The first type:
Mysql>use dbtest;
Mysql>set names UTF8;
Mysql>source D:/www/sql/back.sql;

To import multiple files through the source command, you can create a new Sou.sql file that contains the following command
For example:
SOURCE D:/a1.sql;
SOURCE D:/a2.sql;
When you run


This allows you to import multiple SQL files within a single source command.

The second type:

Later, when the import of the specified character set--default-character-set=utf8, import the backup file again, all smooth.

The command is as follows:
Mysql-uroot-p--default-character-set=utf8 Test_server < Test_service.sql

MySQL Import data command