MYSQL entry 3 _ import local MySQL Data to the SAE Database

MYSQL entry 3 _ import local MySQL Data to the SAE database 1. mySQL character set the default Character Set of MySQL is latin1. When the local MySQL database is exported to SQL and then imported to MySQL of SAE, Chinese characters are garbled, the solution is to set the local mysql Default character set to utf8 to view the current MySQL character set www.2cto.com mysql> show variables like 'character _ set _ % '; change the default MySQL character set $ vi/etc/mysql/my. cnf adds the parameter [client] default-character-set = utf8 [mysqld] character-set-server = utf8init_connect = 'set NAMES utf8' to the client and mysqld to restart the MySQL Background service $ service mysqld restart 2. import/export data is generally imported and exported through the SQL file. The SQL file includes a series of SQL commands, including table creation and data insertion. export data from MySQL $ mysqldump-h localhost-u root-p Database Name>/tmp. SQL 4. import data to the SAE Database: SAE-> my applications-> Service Management-> MySQL-> Manage MySQL-> Import, select/tmp. SQL, file Character Set utf8, and SQL compatibility mode MYSQL40. After import, you can view the newly imported data table in the MySQL management interface. error Handling if a LOCK error is prompted during SAE import, the error occurs in/tmp. delete all locks in SQL, UNLOCK related statements can be 6 reference instance http://oatmental123.sinaapp.com/slim/index.php