MySQL Forums
Forum List  »  Data Recovery

data base recovery
Posted by: Thor Pfosten
Date: November 11, 2020 03:45AM

Hi there,

our server crashed...
We were able to restore the data files, i.e. the folder is named like the database we'd like to recover with tables similar like:


-rw-r----- 1 mysql mysql 1688 Nov 11 05:02 table1.frm
-rw-r----- 1 mysql mysql 98304 Nov 11 05:02 table1.ibd
-rw-r----- 1 mysql mysql 3305 Nov 11 05:02 table2.frm
-rw-r----- 1 mysql mysql 163840 Nov 11 05:02 table2.ibd
....

Can I recover the database from that files ?
Obviously just to mv the database folder to /var/lib/mysql did not
function. Can you get me started ?

Thanks a lot !

Best,

Thor

Options: ReplyQuote


Subject
Views
Written By
Posted
data base recovery
123
November 11, 2020 03:45AM
43
November 11, 2020 12:16PM
28
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.