Comments on: How to Restore a Single InnoDB Table from a Full Backup After Accidentally Dropping It https://www.percona.com/blog/restore-single-innodb-table-full-backup-accidentally-dropping/ Thu, 11 Apr 2024 23:12:15 +0000 hourly 1 https://wordpress.org/?v=6.5.2 By: M. Keijzer https://www.percona.com/blog/restore-single-innodb-table-full-backup-accidentally-dropping/#comment-10970204 Fri, 18 Jan 2019 17:07:06 +0000 https://www.percona.com/blog/?p=41786#comment-10970204 Maybe it is possible to explain when a DROPPING the table is not working… (doesn’t exist in engine, or ‘doesn’t exist’, in case of a corrupted table:

1. stop mysql, delete the frm and ibd-files corresponding the table
2. copy a backup-frm table
3. start mysql
4. NOW dropping had to work, then you can CREATE TABLE

maybe give the statement UNLOCK TABLES at the end

]]> By: CreateIT https://www.percona.com/blog/restore-single-innodb-table-full-backup-accidentally-dropping/#comment-10967901 Tue, 21 Mar 2017 18:39:49 +0000 https://www.percona.com/blog/?p=41786#comment-10967901 Thanks for sharing with the info! It helped me a lot! Regards

]]>