MySQL Forums
Forum List  »  Data Recovery

Restoring a cold backup
Posted by: Andrew Badi
Date: April 21, 2020 05:58AM

Bear with me, I am new at this MySQL stuff.
I have a cold backup of my databases. By this, I mean they are the physical files (.frm, .ibd). I had read (using Google) that I merely needed to copy them to the physical location of the new database and everything would just work.

I have found this to not be the case.

So, I have several database cold backups. How do I restore them? Copying them to their new computer does not work. I looked through the MySQL documentation and it talks about making a cold backup, but not restoring one, so I assume there is some level of common MySQL knowledge I am missing.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Restoring a cold backup
196
April 21, 2020 05:58AM


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.