code_junkie

MySQL won't maintain character information while importing

Nov 12th, 2011
53
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. $ mysqldump -uxxx -p xxx > data.sql
  2. $ iconv -f UTF-8 -t ISO-8859-1//TRANSLIT data.sql data.iconv.sql
  3.  
  4. $ /opt/mysql5/bin/mysql -uxxx -p -Dxxx < data.iconv.sql
  5.  
  6. mysqldump --set-charset ...
  7.  
  8. SET @saved_cs_client = @@character_set_client;
  9. SET character_set_client = utf8;
  10.  
  11. CREATE TABLE ...
  12. ...
  13. ...
  14. SET character_set_client = @saved_cs_client;
Add Comment
Please, Sign In to add comment