How to restore MySQL old databases?
Posted by: Jorge Hernandez
Date: August 10, 2018 01:00PM

Hey guys,

I have a server that crashed, I didn't have the opportunity to export my MySQL databases to sql files, I only have the files from a previous backup of the server, so I built a new server and I'm trying to put the folders (database plus .frm files for tables) for the databases in /var/lib/mysql with the same permissions that the default databases came with.

When I login and run a show tables; it shows me the tables that are in the databases, but when I try to run a select, it says table doesn't exist.

What can I do to fix my tables?

Thanks,

Options: ReplyQuote


Subject
Written By
Posted
How to restore MySQL old databases?
August 10, 2018 01:00PM


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.