recover dropped tables

[expired user #7561]'s profile image [expired user #7561] posted 10 years ago in General Permalink
Hello, i was backing-up my database and accidentally had the drop table box checked with the two create boxes. After the backup
All my data cannot be seen in the database
Plse someone help me on how to get the data.

tanxs
kalvaro's profile image kalvaro posted 10 years ago Permalink
Creating a backup copy will not destroy your current data. You must have done something else.

Whatever, if you do have a copy, just load it again (possibly in another temporary database so you have the chance of having a proper look at it).
TTSneko's profile image TTSneko posted 10 years ago Permalink
In the EXPORT SQL window, one can not DROP without CREATE. You told HEIDI to create a backup and then drop the respective database & tables instead of creating a backup and leaving everything else alone.

Simply re-import your backup: unpack the ZIP, then open the FILE menu and run LOAD SQL FILE. The backup will be imported to a query window (named according to your backup name). Press [F9] or click the EXECUTE SQL button.

Please login to leave a reply, or register at first.