MySQL Forums
Forum List  »  Data Recovery

Re: data base recovery
Posted by: Laura Scott
Date: February 12, 2021 07:25AM

I've had the exact same problem only having the files as backup.

What i did to solve it was to copy the database files into /var/lib/mysql/yourdb and the ibdata1 which is placed in /var/lib/mysql.

I was then able to verify that i could access the tables mysql -u root -p dbname and the querying some of the tables that were previous corrupted.

I made a dump of the database afterward with mysqldump -u root -p[root_password] [database_name] > dumpfilename.sql

You can also check this software:

Options: ReplyQuote

Written By
November 11, 2020 03:45AM
November 11, 2020 12:16PM
Re: data base recovery
February 12, 2021 07:25AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.