I am running OS X with mySQL 8.0.22 running natively. A few weeks ago had to reinstall mySQL as I could not get it to start. I made a backup of all the folders under '/usr/local/mysql/data'.
When mySQL was installed again it had wiped all the databases.
The data inside these DB is in no way critical, but I remembered today I was working in a WordPress site with a page builder, hence all info is stored in the DB tables.
I would like to find a way to restore this database, but every article I have read mentions "ibd and frm" files.
There is not a single frm file from the backup I made.
Is there any way of recreating this DB at all or is it a lost cause?
Thanks!
.frm
files just contain the table schema definition. If you haveidb
files without thefrm
files, you are essentially missing all of the metadata about table definitions. Do you have that metadata elsewhere? (Such as a source control system?) If so, there's this..frm
files.