Search code examples
mysqlbackupdatabase-restore

Restore mysql lost table


I accidentally deleted a table in my mysql database. After that I've restored this table from backup which is scheduled daily at 00:01. But there are lost data from 00:01 to 12:34. Is there a way to restore these records? Table engine is myisam.


Solution

  • Not possible, the data between your scheduled backup and the removal is lost unless you performed some other backup routines or did some query logging in that timeframe