Apache Friends Support Forum

Hello,

because of a potential corrupted ibdata1 file i made a backup of the data folder and copied the content of the backup-folder into the data folder.
Before this the MySQL server wont start, now it starts, but the tables are all empty.

What i have to do to restore the data from the old data files?

Many Thanks in advance

I uploaded the mysql_error.log of one start attempt with the old data:


Log:
https://pastebin.com/GNxSnnEc

I dont know why this happens.
Had no Problems before

Change wrote: and copied the content of the backup-folder into the data folder.

That does not work. The backup folder is for internal MariaSQL Data only, not for user backups. If you simply copy the contents of the backup folder, you probably destroy all data. Instead you must create your own backups.

Thanks for your answer. I know that the backup folder has just a clean server backup inside.
I just copied them to data folder to go sure its the corrupted ibdata file.

Now i copied the old data-files (which i backuped for myself before) back in but the ibdata seems to be corrupted. What i have to do to bring the mysql server up again?

You need a non corrupted ibdata. If you dont have a working backup, i have no idea. Or do new installation, but this does not restore your own data.

I see, i tried to start th mysql server with
innodb_force_recovery=5
(Level 1-4 was not successfull). The server starts (the xampp control panel shows running) but when trying to connect via phpmyadmin it loads infinite and when trying HeidiSQL the program freezes.
Is there another possibility to create a backup of a corrupted ibdata file or to export the data from it?

No, corrupted means corrupted.

Are you really sure?
I tried the Demo of the Software Stellar Repair for MySQL it wa able to show all databases, tables and data.
Unfortunatelly you need a paid Licence to Export these Data. But 200 € is way to much
But it shows, that the data is still readable, isn't it?

Of course it depends on the amount and kind of corruption. Without any further knowledge its impossible to say if it can be recovered or not. Anyway, having a full working backup is always the best solution. I cannot help you on that.

I see, can you maybe recommend alternative software to restore data like the Stellar Repair does?

No.