Use the MySQL command line to import large files

I tried to import a m SQL statement last night. I used phpMyAdmin and it failed to import it for one night. So I had to use the command line. The result showed that the command line was efficient,

It takes only a few minutes to import a m SQL statement. It seems that the original method is the most effective method. Generally, use the following command line:

Mysql-u root-P dB E:/DB. SQL

MySQL will prompt you to enter the password, and then you can, so that you can directly wait for MySQL to import all the data.

The command line has the highest efficiency.