I just dropped my company's table and realized that the SQL backup I made was for STRUCTURE not DATA. I need to restore the data immediately.... is there anyway to do this? I'm using PHPMyAdmin and all i've done so far is
我刚刚删除了公司的表,并意识到我所做的SQL备份是针对STRUCTURE而不是DATA。我需要立即恢复数据....无论如何要做到这一点?我正在使用PHPMyAdmin,到目前为止我所做的一切都是
DROP TABLE USEFUL_TABLE AND CREATE TABLE IF NOT EXISTS USEFUL_TABLE AND (IN DESPERATION) ROLLBACK
DROP TABLE USEFUL_TABLE并创建表,如果不是可用的和(在DESERATION)ROLLBACK
Is there anyway to get the data records back?
反正有没有得到数据记录?
Edit
Thanks for the comments, and thank God above that I found an obscure backup somewhere that I was able to restore! Just as a tip for anyone as hasty and careless as myself, BEFORE any backup/export operations, always make sure you've selected the Dump all rows option when exporting data for a backup. I didn't, and I didn't even check to confirm that the SQL had the rows dumped.
感谢您的评论,感谢上帝,我在某处找到了一个我能够恢复的模糊备份!对于像我一样仓促和粗心的人,在进行任何备份/导出操作之前,始终确保在导出备份数据时选择了“转储所有行”选项。我没有,我甚至没有检查确认SQL有转储的行。
1 个解决方案
#1
0
DDL commands can't be rolled back in MySQL. You need to restore from a backup.
DDL命令无法在MySQL中回滚。您需要从备份还原。
If you need to recover data that was committed since the latest backup, perform point in time recovery with binary logs. But this depends on having binary logging enabled, and having a continuous set of binary logs since the date of the last full backup.
如果需要恢复自最新备份以来提交的数据,请使用二进制日志执行时间点恢复。但这取决于启用二进制日志记录,并且自上次完全备份日期以来拥有一组连续的二进制日志。
#1
0
DDL commands can't be rolled back in MySQL. You need to restore from a backup.
DDL命令无法在MySQL中回滚。您需要从备份还原。
If you need to recover data that was committed since the latest backup, perform point in time recovery with binary logs. But this depends on having binary logging enabled, and having a continuous set of binary logs since the date of the last full backup.
如果需要恢复自最新备份以来提交的数据,请使用二进制日志执行时间点恢复。但这取决于启用二进制日志记录,并且自上次完全备份日期以来拥有一组连续的二进制日志。