Database Backup Hangs

[TriMe]

I've been trying to backup my database but it keeps stalling at "Processing: ghntagthread"

The webpage says done as you can see in the screenshot.

Any suggestions on what may be the cause?

http://img187.imageshack.us/img187/3523/32ax9.jpg

[briansol]

after a certain point, making backups via web interface won't be possible.

Large sites need to have an ssh dump, or something else server-side.

[Wayne Luke]

The most reliable method of backing up and restoring a database is with shell access via 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

[TriMe]

The most reliable method of backing up and restoring a database is with shell access via 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

That's a big help!

Thanks for your time!

TriMe :)