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: https://www.stellarinfo.com/mysql-repair.php

Options: ReplyQuote


Subject
Views
Written By
Posted
120
November 11, 2020 03:45AM
43
November 11, 2020 12:16PM
Re: data base recovery
27
February 12, 2021 07:25AM


Sorry, only registered users may post in this forum.

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.