Convert vBulletin DB encoding to UTF-8

great help @ http://mansurovs.com/tech/converting-vbulletin-to-utf-8

these are the exact commands that worked for me

mysqldump -u VB_forum_DB --default-character-set=latin1 --opt --ignore-table=VB_forum_DB.customavatar --ignore-table=VB_forum_DB.customprofilepic --ignore-table=VB_forum_DB.picture --ignore-table=VB_forum_DB.socialgroupicon --ignore-table=VB_forum_DB.socialgrouppicture VB_forum_DB > VB_forum_DB.sql
 
mysqldump -u VB_forum_DB --opt VB_forum_DB customavatar customprofilepic picture sigpic socialgroupicon socialgrouppicture > VB_forum_DB_images.sql
 
iconv -c -f WINDOWS-1256 -t UTF8 VB_forum_DB.sql -o VB_forum_DB_utf8.sql
 
mysql -u VB_forum_DB  VB_forum_DB < VB_forum_DB_utf8.sql 
 
mysql -u VB_forum_DB  VB_forum_DB < VB_forum_DB_images.sql

Recommended posts:


Tags : more-58

This entry was posted on Saturday, June 19th, 2010 at 5:45 am and is filed under Solutions. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.


 Top