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.
+3
A:
Afaik there is a backup mechanism if you had enabled the log of all queries. If you didn't, the data is lost forever.
WarrenFaith
2010-03-02 10:53:24
Actualy I'm not sure if queries are logged. Where does MySql store logged queries?Thanks..
HasanGursoy
2010-03-02 13:35:29
That depends on your operation system and on you configuration. Check your config file (mostly my.cnf) for more information.
WarrenFaith
2010-03-02 14:05:29
+1
A:
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
ChrisR
2010-03-02 10:58:28
There are no any other backups. I don't know what query logging is. If you mean any open resultset no I don't have it either.
HasanGursoy
2010-03-02 13:33:44