Large File SQL Import issues

Today encountered a more difficult problem, SQL file is too large, import database too cumbersome, more than 1G after Nodpad, sublime and other editors can not open, this has a more awkward problem.

Because it is a local test, the environment is windows, and finally the command line is used to import SQL

The statement format is: Mysql-h host address (native localhost)-u user name (root)-p database name < data file to import (e.g. D:\mysql\phpcms.sql)

For example: Mysql-h localhost-u root-p phpcms< D:\mysql\phpcms.sql

This is the local import, indicating that the database databases to be imported exist.

Large File SQL Import issues