Solve Chinese garbled characters After Godaddy restores the MySQL database

1. Open the backed up SQL text in notepad to ensure that the data in the file is properly displayed. 2. view the storage format of this text, typically ANSI (Chinese generally GBK or gb2312) and UTF-8.3. if the file storage format is ANSI, add the following statement at the top of the SQL file :/*! 40101 set names GBK */; if the file storage format is UTF-8, add the following statement at the top of the SQL file :/*! 40101 set names utf8 */; 4. Save the settings and use the modified SQL file to restore the MySQL database.

 

My MySQL backup files are too large, and over 300 m, ultraedit, and editplus are difficult to handle. The results are handled by using winhex to directly modify the SQL file header.