MySQL 8 Database Recovery

[Aleksa Djordjic]

So ... i was converting my Windows Server in to Linux and i backed up EVERYTHING .... except MySQL, i remembered this after i installed Ubuntu so the files did not get overwrote during the switch.

I was able to recover the whole `C:\ProgramData\MySQL\MySQL Server 8.0` directory and files inside.

 

One problem ... i cant just copy that backup over to new MySQL install (i installed MySQL on my Main PC with Windows 10 just to test it and convert everything in to .sql files and back them up)

If i try to do that with the files that actually need to be copied (ibdata, ib_logfileX...) MySQL wont start...

 

Is there any way to recover the InnoDB databases and tables with ibd files or what can i do to recover it in some other way?

I was searching around and everything that i found required some .frm file which i couldnt find anywhere, im guessing MySQL 8 doesnt use them anymore?

 

Imma add some pics of files that i have in to attachments

And inside the Data folder:

The most important Database from there is that `admin_tracker`, i need to recover that, other stuff is not really needed ....

Files inside that `admin_tracker` folder:

 

Thank you for any help!