Here's the situation. I have all the database files. They are .frm and .ibd files, so this means the db is in INNODB format. There is only one ibdata1 file, so the individual databases did not have their own ibdata1 file.
The mysql database installation is brand new and is version 8.0.23, but the files were from a mysql 5.6 db. There is no existing mysqldump file of the dbs. The only evidence they ever existed is the files in the directories.
Is the ANY way to restore the dbs? Or are they gone for good? Is there a mysql pro who could restore these dbs for a fee?
Back in the good old days of ISAM, all I had to do was create the database and restart the server, and it would "read" the files, and the database was "restored". But that's clearly not possible with INNODB.
Am I out of luck? Three of the dbs were Joomla, Wordpress, and Wikimedia, if that matters.
The mysql database installation is brand new and is version 8.0.23, but the files were from a mysql 5.6 db. There is no existing mysqldump file of the dbs. The only evidence they ever existed is the files in the directories.
Is the ANY way to restore the dbs? Or are they gone for good? Is there a mysql pro who could restore these dbs for a fee?
Back in the good old days of ISAM, all I had to do was create the database and restart the server, and it would "read" the files, and the database was "restored". But that's clearly not possible with INNODB.
Am I out of luck? Three of the dbs were Joomla, Wordpress, and Wikimedia, if that matters.
Comment