Recover database from .frm and .idb files

1

My backup was incomplete and corrupted my ibdata database, now my database does not access my tables. Giving error!

I do not care about the data! But I really need the structure of the tables. Is there a way to retrieve the structure from these files that I quoted?

If I click to open some table in the database the following message appears

"Table 'meubanco.name" does not exist in engine "

    
asked by anonymous 06.07.2017 / 21:42

1 answer

1

As stated in the question, my ibdata was corrupted. In the first moment my reaction was to copy the folders of the created tables and reinstall XAMP. The folders for the created database are in place xampp/mysql/data/pastaBancoDeDados

After the reinstallation, I reattached the database folders to the mysql/data/pastaBancoDeDados installation location.

When I opened the localhost/phpmyadmin panel, I saw that when I tried to open some table in the saved database, I had the following error "Table 'meubanco.nometabela' doesn't exist in engine" .

I then opened my database for Heidi and exported the table as SQL. I deleted the database folder in the mysql/data/pastaBancoDeDados directory, right after I went to the localhost/phpmyadmin panel and created a new database with the same name as the previous one and imported the sql heidiSql generated.

And it worked. I retrieved every structure of the tables with all the settings. I just lost the data saved in the table.

  

This is not a definitive answer, but it worked for me and can be useful for someone else!

    
06.07.2017 / 22:17