469,342 Members | 5,865 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,342 developers. It's quick & easy.

Is it possible to restore these databases

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.
Aug 21 '21 #1
0 1460

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Thomas Bartkus | last post: by
3 posts views Thread by butatista | last post: by
18 posts views Thread by Ron Johnson | last post: by
5 posts views Thread by abelbfilho | last post: by
1 post views Thread by nikb | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by haryvincent176 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.