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

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close