. mysql Database import error: 40101 SET @OLD_CHARACTER_SET_CLIENT =@ @CHARACTER_SET

Friends to apply for a free MySQL database space to do the test, this morning to import the database to try, anyway, a few times lead a mistake. Error Tip:

The code is as follows	Copy Code
/*!40101 SET @OLD_CHARACTER_SET_CLIENT =@ @CHARACTER_SET_CLIENT * *;

My local version of MySQL is: 5.1.45, coding is utf-8

The MySQL version of the server is: 5.1.33, encoding I also turned the utf-8.

Initially thought is a version of the problem, but the version is 5.1.x, should not be a lot of related. I also built a library on my own machine to try, found that can be successful, what solution? Let's ask Gu brother.

From the crazy little donkey Baidu Hi find the article to solve the problem as follows:

-------------------------------

Cannot import MySQL database when imported
MySQL 5n to 4n conversion of Chinese garbled processing experience

Problem: Because the 4n version of the database is encoded as a latin1,5n version of the database encoded as UTF8. caused.

Remove the following code

The code is as follows	Copy Code
/*!40101 SET @OLD_CHARACTER_SET_CLIENT =@ @CHARACTER_SET_CLIENT * *; /*!40101 SET @OLD_CHARACTER_SET_RESULTS =@ @CHARACTER_SET_RESULTS * *; /*!40101 SET @OLD_COLLATION_CONNECTION =@ @COLLATION_CONNECTION * *; /*!40101 SET NAMES UTF8 * *;

Use phpMyAdmin import, file character Set selection latin1, everything is OK.

Experience: Use phpMyAdmin to export in default state, save the exported UTF8 encoded file as an ANSI encoding in Notepad.

Open a text file, replacing all GBK as Latin1

Actually, I just took that part

The code is as follows	Copy Code
/*!40101 SET @OLD_CHARACTER_SET_CLIENT =@ @CHARACTER_SET_CLIENT * *; /*!40101 SET @OLD_CHARACTER_SET_RESULTS =@ @CHARACTER_SET_RESULTS * *; /*!40101 SET @OLD_COLLATION_CONNECTION =@ @COLLATION_CONNECTION * *; /*!40101 SET NAMES UTF8 * *;

get rid of it and execute successfully.