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 folderData
complete. The structure is:...\Mysql\Data\\[minhaBaseDeDados]\
– Rovann Linhalis
My goal would be to recover the database data and not the structure of the tables, but thank you Rovann.
– AmiltonTeles
but database data, will be inside these folders, each folder for a database, external files are only from mysql system
– Rovann Linhalis
You can try this procedure the friend recommended: https://dba.stackexchange.com/questions/54007/mysql-backup-from-ibdata1-ib-logfile1-ib-logfile0
– RafaBR1