Import large files under MySQL windows

Go to your MySQL bin directory first

CD D:/php/mysql/bin

Enter command mysql-u user name-p password database name < file path < import > for export

Mysql-u root-p root eee < d:/eee.sql

In the event of the following error

MYSQL server has gone away

Please modify the configuration file under MySQL My.ini 30M for your file size.

Max_allowed_packet = 30M

If the Chinese garbled please try the following

Mysql-u root-p root--default-character-set=utf8 eee < d:/eee.sql

If the Chinese is garbled please try other characters GBK and so on. I have encountered this problem, SQL file encoding is UTF8, the database is also UTF8 modified code to UFT8 garbled, modified to GBK is normal.

Import large files under MySQL windows