ERROR ERROR 1204(HY000) Unkonw mysql Server host…
use mysqldump command to backup the database to an external file, but when using mysql command line to import the backup data, ERROR 2005(HY000) unkonw mysql server host… error
Solutions:
because in peacetime work often use mysqldump command to export the backup data, and then use the mysql client source command in the command line tools to import data, never out of the fault, the only difference is the character set is different, this time to import the database character set is utf8, so they are associated with the need for mysql client command line tools specified character set, after reviewed the help, Open mysql client tool mysql-uroot-p – default-character-Set = UTf8 with the following command, then import the backup data, and everything is OK.
Read More:
- ERROR 2005 (HY000): Unknown MySQL server host
- ERROR 2002 (HY000): Can’t connect to MySQL server on ‘localhost’ (10061)
- Error 2003 (HY000): can’t connect to MySQL server on ‘localhost’ (10061)
- Cannot connect to MySQL server on “host” (113)
- Host is not allowed to connect to this MySQL server
- Solve MySQL error 2002 (HY000)
- Mysql start slave error 1201 (HY000)
- Solution to error 2002 (HY000) in MySQL
- Solution to error 2002 (HY000) in MySQL login startup
- [MySQL] error 1396 (HY000): Operation create user failed for ‘MySQL’ @’localhost ‘
- SQL exception handling – MySQL error 1005 (HY000): can’t create table ‘TMP’ (errno: 13)
- ERROR 2000 (HY000): Unknown MySQL error
- MySQL error 1205 (HY000): lock wait timeout exceeded; try restarting transaction
- MYSQL:ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
- (error when importing database): MySQL 2006-mysql server has gone away
- mysql load data infile ERROR 13 (HY000): Can’t get stat of
- The MySQL service suddenly hangs up with the error message can’t connect to MySQL server on ‘localhost’ (10061)
- About error 1005 (HY000) in MySQL: can’t create table ‘_______ ‘(errno: 150) fool’s plan
- MySQL Workbench: Error Code: 2013. Lost connection to MySQL server during query solution
- MySQL error: error 1010 (HY000) when deleting database