Author Andriy Lysyuk.
Unfortunately, human mistakes are inevitable. That’s how life is.
DROP DATABASE or
DROP TABLE may
destroy critical data on the MySQL server. Obviously, backups
would help, however they’re not always available. This situation
is frightening but not hopeless. In many cases it’s possible to
recover almost all the data that was in the database or
Let’s look at how we can do it. The recovery plan depends on whether InnoDB kept all data in a single ibdata1 or each table had its own tablespace. In this post we will consider the case when
innodb_file_per_table=OFF. This option assumes
that all tables are stored in a common file, usually located at
One Wrong Move, And The Table’s Gone
For our scenario, we use …[Read more]