Mysql command to import sql data backup method

The following is the command line import sql data, you need friends can refer to the next. My personal practice is: phpmyadmin export utf-8 insert mode abc.sql
ftp abc.sql to the server
ssh to the server
mysql-u abc-p use KKK (database name, if not create database KKK) set names 'utf8' source abc.sql
Note: I see set character set utf8; argument, that does not work, Chinese garbled.
First open the command line console mysql
Perhaps the order is as follows:
mysql-u root-p database_name
You may then be prompted to enter the corresponding password
The following command may be useful to you when you want to change a database
mysql> use database_name
Then use the following command
mysql> source d: datafilename.sql
Of course, you need to figure out where the file path, and correctly use the mysql directory where he entered into the subdirectory of bin. Enter the implementation of the import command sql.
For example: your mysql installed in d: mysql
Proceed as follows:
Start -> Run -> Enter CMD
D:
cd mysqlbin
mysql-u root-p123456 test <d: a.sql
Where root is your mysql administrator user name, 123456 for the password test for the database name d: a.sql backup data file location.
If it is Windows, from the command prompt to the MYSQL file directory Bin folder, execute the command
mysql-u root-p databasename <db.sql
Where root is your MYSQL user name, databasename is the name of your database, and db.sql you are the file. Note that you must put db.sql into the bin folder can be. Of course, the location of the file can be changed.
If it is LINUX, direct input
mysql databasename <db.sql