Inadvertently rubbed the desired table via phpmyadmin . There is a possibility that the necessary data was saved in ibdata1. How to extract data from there?

I work with the database in the assembly XAMPP under Windows.

  • one
    And the full backup was shot before? transaction log was kept? You can try to roll up a log to a saved copy before a certain transaction. I didn’t do it myself, in general I only have an idea. In this book , something similar is considered - BOPOH
  • If it were filmed, the question of restoration would not stand. It was a job of analyzing the data - I cleaned the raw data, leaving the necessary information. And somehow, without looking, he rubbed everything to hell with the really unnecessary tables. - Denis Khvorostin

1 answer 1

If you delete the database via phpMyAdmin, i.e. a regular DROP TABLE request, then the probability that something is left in ibdata1 is almost zero. Especially if your database is not loaded and changes from the transaction log almost immediately apply to the table space in ibdata1. The data and indexes in ibdata1 remain if you accidentally rub the frm file with the definition of a table in the data directory. Then, by creating a similar frm-file, you can access the table in the tablespace (although it is still a task to create it, since MySQL will assume that the table exists and will not allow it to be created using standard tools). If the table is deleted by the SQL query, if you did not have backup copies or did not include binary logs, there is no chance to restore the table.