Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $ mysqldump -uxxx -p xxx > data.sql
- $ iconv -f UTF-8 -t ISO-8859-1//TRANSLIT data.sql data.iconv.sql
- $ /opt/mysql5/bin/mysql -uxxx -p -Dxxx < data.iconv.sql
- mysqldump --set-charset ...
- SET @saved_cs_client = @@character_set_client;
- SET character_set_client = utf8;
- CREATE TABLE ...
- ...
- ...
- SET character_set_client = @saved_cs_client;
Add Comment
Please, Sign In to add comment