PDA

View Full Version : Database backup


newmasalaboard
30 May 2008, 12:07
Hello everyone,

While installing many MOD's i came up a statement - " Backup Database "

Now consider me a newbie, and please suggest me how should i take a backup of my database.I saw the documentation at the vb but i am not able to understand that :(

Can anyone tell me a simple way to backup and restore the database ??

Marco van Herwaarden
30 May 2008, 12:19
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