undelete phy delete

[jis]

I realize I will have to go into the database to undelete a thread I phy deleted.
I have phpmyadmin

can someone post the steps to find this thread and undelete it aka restore?

thank you :)

[Lynne]

If you physically deleted it (which it looks like you are saying you did), it's gone (unless you have a backup database where you can find it). If you only have it soft deleted, then it's still in the database and it can be restored.

[jis]

I did physically deleted it and I do have a backup database - I need to know the steps in the backup database to restore it.

[Marco van Herwaarden]

Please note that restoring a backup will restore your entire board! (so you will loose any posts made after the backup was made).

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