Mysql – Getting Error “Unknown MySQL server host” during importing the sql file

InnoDB is insanely picky about it's config; if something's not right, it'll just give up and go home. To make a change to the log file size without data loss:

1. Revert any config changes you've made to the log file size and start MySQL again.
2. In your running MySQL: SET GLOBAL innodb_fast_shutdown=0;
3. Stop MySQL
4. Make the configuration change to the log file size.
5. Delete both log files.
6. Start MySQL. It will complain about the lack of log files, but it'll create them and all will be well.

For this reason I always use mysqldump --hex-blob.

Re-dump the database encoding the blobs using this switch and it will work.

You can try to import it using a windows mysql client IDE like sqlyog or mysql administrator. It worked for me once.