I accidentally deleted my data in the production database using drop database ... command. I am using InnoDB but I don't enable mysqlbinlog. How to recover the data?
Asked
Active
Viewed 48 times
0
jonrsharpe
- 115,751
- 26
- 228
- 437
5413668060
- 326
- 2
- 15
-
Or perhaps more https://stackoverflow.com/q/25671165/3001761 if you don't have the logs. – jonrsharpe Aug 30 '19 at 10:42
-
please don't do this I need an urgent answer. I do not enable `mysqlbinlog` so the question does not answer me. – 5413668060 Aug 30 '19 at 10:44
-
1See https://meta.stackoverflow.com/q/326569/3001761; if you need urgent help, you should *hire some*. – jonrsharpe Aug 30 '19 at 10:44
-
You should at least have a backup so you may only loose 24hrs of data? – Martin Aug 30 '19 at 11:06
-
I only have `ib_logfile0` `ib_logfile1` `ibdata1` and `ibtmp1` – 5413668060 Aug 30 '19 at 12:06