Topics

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