How do I restore deleted lists from Backup?

[antonia]

Accidently deleted the wrong list. When I restored the database from the previous night's backup though, the deleted list did not return. What files do I need to restore to get the information back?

[don1r]

When you restore a database with a backup copy you should either remove all tables from the database or drop the database entirely before initiating the restore, otherwise all of the data may not get loaded correctly even though the information is in the database backup file.  Another thing you can do is to use a program like WinRAR to view and search your compressed/zipped database file to see if the missing information/list is in the file before you attempt to restore it again.

You can download a free trial version of WinRAR at http://www.rarlab.com/download.htm

[DW]

Assuming the list existed at the time it should have been included in the last days backup...  Restoring a backup will cause you to lose all recent changes to everything throughout the program.  This includes settings, new users, etc.  Since the backup is actually a compressed SQL text file what you could have done is extracted the particular line(s) you needed and ran the queries with a custom MySQL tool such as PhpMyAdmin.

Regretfully if the list is not contained in the backup file you have to restore, and you don't have an 'Export' of all the users on that list so you might re-Import them you may have lost your data.  If this is extremely damaging you might try asking your web host if they have any backups that they can restore.  (keeping your latest one on hand for updating later when you recover the important data)

Regards