473,322 Members | 1,352 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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
1 10899
mwasif
802 Expert 512MB
Percona provides professional services to restore database, free services won't be possible.
Jan 10 '22 #2

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

Similar topics

2
by: Thomas Bartkus | last post by:
Is it safe to say that restoring the directory from a backup would that restore all database data and structure? All usr/pwd and GRANT info? Thomas Bartkus
1
by: Hai-Chu Hsu | last post by:
Hi, I want to restore my databases from the old SQL Server installation into a new installation of SQL Server. My new installation of SQL Server has different data path from the old...
3
by: butatista | last post by:
Please help SQL Server 2000 Standard I am trying to restore databases on my server and am unable to get them to restore using the database option. For example, the location of my backup...
0
by: tram | last post by:
I am using third party software to do the full backups to tape and log backups will be done to local disk. I can restore the full database using third party tool. I need to setup script to recover...
18
by: Ron Johnson | last post by:
On Mon, 2003-08-25 at 16:28, Gregory S. Williamson wrote: > One of our sysads sent this link ... wondering if there is any comment on it from the world of actual users of linux and a database. > >...
5
by: abelbfilho | last post by:
I have a backup image with name DADOSADV.0.DB2.NODE0000.CATN0000.20060812230006.001 and I want to restore it on Windows (in another server). In Windows Server I created this folder structure:...
1
by: GitarJake | last post by:
Hello, I am getting the rather odd error below; hope you can help. RESTORE DATABASE is terminating abnormally. File 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\trial_44testingc'...
0
by: loudfish | last post by:
Hi there, I'm looking to get SSIS to run database backup and restore tasks as part of an overall process. But I have a few problems. 1. The "Backup Database Task" does not seem to allow...
0
by: arulananthi | last post by:
hi, I am getting the rather odd error below; hope you can help. RESTORE DATABASE is terminating abnormally. File 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\trial_44testingc' is...
1
by: nikb | last post by:
I am trying to restore a SQL Server database from a .dat file. An earlier question on how to do this elicited the following answer. " You need to know how the '.dat' file was created in order...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.