Windows MySQL command line import. SQL File

From http://bbs.taohost.net/thread-595-1-1.html

 

Mysql-uusername-pyourpassword yourdatabasename <c: \ sqlfile. SQL

Here, username is the MySQL user name, generally root;
Databasename indicates the name of the target database for which you want to import data;
Xxx. SQL is the directory where your current SQL file is stored; for example, C:/AAA/TTT. SQL

If it is greater than the number, it is exported. There should have been two Commands: mysqldump export and mysqlimport. However, if you use the MySQL command, it will identify it by itself.

The advantage is that the compatibility is good in general. Compared with phpMyAdmin.
Another method is to directly log on to the server and copy the MySQL directory. However, I don't know if there will be compatibility issues.

When phpMyAdmin imports a large SQL file, the browser may stop responding. Therefore, this method should be used when importing a large SQL file.