View Full Version : Forum will not back up
MTGDarkness
02-25-2009, 03:32 PM
Up until recently, I have been backing up to a file on the server, downloading it, and then deleting it. But all of a sudden, this stopped working. It keeps on getting stuck at vBulletin_pollsvoted and won't continue. :( What could be the problem?
BSMedia
02-25-2009, 04:28 PM
Its probably timng out especially if you have a lot of data in the pollsvoted table.
Backing up that way isn't recommended and you should consider learning how to backup via SSH or mysqlhotcopy to prevent having incomplete backups or corrupt ones should the time ever come and you need one.
Lynne
02-25-2009, 04:37 PM
From the manual:
Backing Up The Database via SSH/Telnet (http://www.vbulletin.com/forum/../docs/html/maintenance_ssh_backup) or
Backing Up The Database via phpMyAdmin (http://www.vbulletin.com/forum/../docs/html/maintenance_phpmyadmin_backup)
Restoring The Database via SSH/Telnet (http://www.vbulletin.com/forum/../docs/html/maintenance_ssh_restore) or
Restoring The Database via phpMyAdmin (http://www.vbulletin.com/forum/../docs/html/maintenance_phpmyadmin_restore)
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)
MTGDarkness
02-25-2009, 04:37 PM
I'm pretty sure my host doesn't allow SSH access. What's MySQLHotCopy?
Lynne
02-25-2009, 04:38 PM
They are different applications to do backups. Talk to your host and see what they may have available for you to use to do a mysql backup.
MTGDarkness
02-25-2009, 05:13 PM
Okay, thanks.
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.