Here is using mysql command-line to import large sql data.Maybe you will need it when you want to import a large sql file .
For people who regularly use MYSQL,myadmin is an essential tool. This is a very powerful tool, almost all database operations can be done, but it also has a weakness for import large data files to the remote server will be excruciatingly slow, and even the long-term response.
Why would this situation? When we choose a sql data file and submit, the server first to upload files to the server before performing the import code to import data into the database. We know phpmyadmin uploaded data files via the web, web upload is very unstable, especially when network is not very good, which is why we have so many times in front of the computer waiting eagerly for the final but did not result reasons. Read more