PDA

View Full Version : Database backup feature doesn't work on export


volgan
03-24-2009, 10:48 PM
ok heres my issue

I do weekly DB backups and this week i downloaded my DB through the vbulletin db backup feature, so when i open it i get all these weird symbols on the tables

Attachments
signature tables,
picture tables

any thing that has to do with anything being uploaded into vbulletin and it doesn't show right in the sql file i downloaded so is their a way to fix this issue for me because where planning on moving to another host soon and we cannot move yet because our db backups are funky looking, so can u help us with this known issue where experiencing ?:confused:

Dismounted
03-25-2009, 06:23 AM
The only reliable method of backing up and restoring a database is with shell access via telnet or ssh. This is because backing up with a PHP script like that in the Admin CP or phpMyAdmin can result in PHP timeouts errors and an incomplete backup file. Please see the instructions here:

Backup:
http://www.vbulletin.com/docs/html/maintenance_ssh_backup

Restore:
http://www.vbulletin.com/docs/html/maintenance_ssh_restore

P.S. If you don't have shell access, some people have also reported success with these scripts:

MySQLDumper:
http://www.mysqldumper.de/en/index.php

MySQLHotxcopy:
http://www.vbulletin.com/forum/showthread.php?t=134821&highlight=mysqlhotcopy

Bigdump:
http://www.ozerov.de/bigdump.php