Recover Data from Mysql

Asked

Viewed 844 times

0

I uninstalled mysql, did not backup the database, but backed up the files: ibdata1, ib_logfile0 and ib_logfile1.

The ibdata1 file has 17GB, in my.cnf innodb_file_per_table=0.

How do I recover this data ? Is there any software or procedure that makes me have this data back?

Note: I have the xampp installed and I intend to test with it.

  • your database data is inside a folder, are files .frm, .MYD, .MYI. These files you saved are only files from the bank itself. You should have saved the folder Data complete. The structure is: ...\Mysql\Data\\[minhaBaseDeDados]\

  • My goal would be to recover the database data and not the structure of the tables, but thank you Rovann.

  • but database data, will be inside these folders, each folder for a database, external files are only from mysql system

  • You can try this procedure the friend recommended: https://dba.stackexchange.com/questions/54007/mysql-backup-from-ibdata1-ib-logfile1-ib-logfile0

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.