MySQL Forums
Forum List  »  Data Recovery

Re: Newbie advice on restoring and upgrading databases
Posted by: Peter Brawley
Date: August 10, 2020 08:45PM

> In my old installation, my database files
> are in two folders named mysql and mysql56

If mysql was a subfolder of mysql56, that strongly suggests you had a mysql 5.6 installation with the mysql folder holding the privileges db---its name is mysql.

> I made a backup copy of my ONLINE databases

And that mySQL instance uses what MySQL version?

> I just tried importing another MYD file from my
> older mysql56 folder, and I got this error message ...

You tried importing it how exactly?

> I never had time to figure out all the intricacies of MySQL

Evidently not. I agree that before you do more harm to your files, your best bet will be to hire a local MySQL pro to fix what can be fixed in your setup. And though there are very few who understand "all the intracies" of MySQL, you need to be aware that a kernel of such basic knowledge is essential for managing data in a MySQL instance.



Edited 1 time(s). Last edit at 08/10/2020 08:46PM by Peter Brawley.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Newbie advice on restoring and upgrading databases
57
August 10, 2020 08:45PM


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.