Shared Hosting
Shared HostingKnowledgebase
Portal Home > Knowledgebase > Articles Database > mySQL DB Recovery
mySQL DB Recovery
 |
 |
 |
Posted by YUPAPA, 09-04-2008, 02:25 AM Is there any way to recover a database when: 1.) There is no backup 2.) The server has no binlog enabled 3.) The records are deleted using the DELETE SQL command I only need to recover a few tables. Those deleted records seem to be exist in the table and I guess they are just marked as "delete" so that they can be overwritten with new data. Current situation and findings: -------------------------------------------------------------- All rows in the table were destroyed by issuing the DELETE command The header shows the # of records exist and deleted there. The # of deleted records match the # of total records in the table prior deletion. Can we convert from binary to hex and edit them directly and rebuild the binary file after? There could be a lot of work to do this, but I guess it doesn't hurt to try if this plan does work. Thanks
Add to Favourites 
Print this Article
Also Read
