To import

Type the following command to import sql data file:

$ mysql -u username -p -h localhost>< data.sql

In this example, import 'data.sql' file into 'blog' database using Sathish as username:

$ mysql -u sat -p -h localhost blog < data.sql

If you have a dedicated database server, replace localhost hostname with with actual server name or IP address as follows:

$ mysql -u username -p -h 202.54.1.10 databasename < data.sql

OR use hostname such as mysql.cyberciti.biz

$ mysql -u username -p -h mysql.cyberciti.biz database-name < data.sql

If you do not know the database name or database name is included in sql dump you can try out something as follows:

$ mysql -u username -p -h 202.54.1.10 < data.sql

If you want a GUI tool then you could probably use SQLyog

参考文献：

http://stackoverflow.com/questions/11407349/mysql-how-to-export-and-import-an-sql-file-from-command-line

ITPub博客