Database Backup

[RichieScott1]

When I use the admincp to backup my database, it stops at vb_postindex and never completes the backup. Has anyone ever heard of this?

[Eikinskjaldi]

When I use the admincp to backup my database, it stops at vb_postindex and never completes the backup. Has anyone ever heard of this?

admincp is notoriously bad at backing up large databases.

toggle the option to use mysql indexing instead of vb indexing, and the postindex table will go away.

...and get a better back up system

[Dismounted]

Many people have reported success in backing up databases with MySQLDumper (http://www.mysqldumper.de/en/). But the best way to back up databases is through SSH.

[Marco van Herwaarden]

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

[therogueforums]

Many people have reported success in backing up databases with MySQLDumper (http://www.mysqldumper.de/en/). But the best way to back up databases is through SSH.
You, Sir/Ma'am, are a God-send for that suggestion. I was in a real tight pinch last night- current host was being rather abusive, locked out phpmyadmin, and wouldn't give me a copy of the database. And it was way too large to export through the ACP. the SQLDumper worked frikkin' magic for me.

[helpmehost]

thanks big help