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 me

mysqldump -u VB_forum_DB --default-character-set=latin1 --opt --ignore-=VB_forum_DB.customavatar --ignore-=VB_forum_DB.customprofilepic --ignore-=VB_forum_DB.picture --ignore-=VB_forum_DB.socialgroupicon --ignore-=VB_forum_DB.socialgrouppicture VB_forum_DB > VB_forum_DB.

mysqldump -u VB_forum_DB --opt VB_forum_DB customavatar customprofilepic picture sigpic socialgroupicon socialgrouppicture > VB_forum_DB_images.

iconv -c -f -1256 -t UTF8 VB_forum_DB. -o VB_forum_DB_utf8.

 -u VB_forum_DB  VB_forum_DB < VB_forum_DB_utf8. 

mysql -u VB_forum_DB  VB_forum_DB < VB_forum_DB_images.