PDA

View Full Version : Backup of SQL database (any ideas?)


93Corvette
03-29-2010, 05:10 AM
I have a forum SQL database that I need make a back of. The total size is 192 tables with 186.38MB.
The largest table are:
Table--------------record-------Size------
attachment--------344----------156.01MB
post----------------9319--------9.55MB
picture-------------68-----------4.32MB
template----------764---------3.09MB
phase--------------11764------2.76MB
cpsession-----------0-----------1.24MB
pmtext-------------1350-------1.22MB
postedithistory-----596--------1.60MB
session-------------5-----------1.03MB

I try to do backup's however, the table being so large the "phpMyAdmin", "Backup Wizard", "Mysql Dumper" can't back them up. Is there any other way of backing this database up without using SSH? My host charge $24 per year for SSH, and having a forum that doesn't charge for membership, nor having advertisements, I truly don't want to pay $24 if there is another way of doing it.

Any advise?

ProFifaLeagues
03-29-2010, 06:02 AM
Search for PaulM's Mod im sure there is a version for 3.8.4 and 4.0 and above and i can confirm it works well
heres the link in fact https://vborg.vbsupport.ru/showthread.php?t=231481
or this one for 3.8
https://vborg.vbsupport.ru/showthread.php?t=201319

Marco van Herwaarden
03-29-2010, 07:58 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.net

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

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