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
recover dropped tables
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.
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.