[Forum] How to restore our database using a dump of the database??/

[Thalada]

IS there any method to restore our database from our dump of the database??? Anything needs to be done?? I just tried to importing them through php my admin, nothing really happened.

[Steve Machol]

The only reliable method of restoring a database is with shell access via telnet or ssh. This is because restoring with a PHP script like that in phpMyAdmin can result in PHP timeout errors and an incomplete database. Please see the instructions here:

http://www.vbulletin.com/docs/html/maintenance_ssh_restore

Note: Some people have 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 (restore only):

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

[Thalada]

The thing is that i don't have a proper backup of my database. It's just an dump. This is what my host said

We do take regular backups, however non-standard InnoDB tables are not compatible. When you added the database from your control panel that warning would have been shown to you warning you of the compatibility issues with InnoDB tables. We can certainly provide you a dump of the database from the server in it's current state, just not from our backups. I've made a dump of the database for you and you can download from the following URL.

[Steve Machol]

A 'dump' should be a proper backup. You need to contact your host about this.

[Thalada]

Okay, finally i have figured out the thing. My other admin has just deleted the

All the forums & categories in the forum manager. So even i made the right back up. I am not able to restore my threads or posts. So can anything be done in this case??

[Trevor Hannant]

You really need to restore back to the last full backup rather than selective restoring as this can cause more problems than it would solve.