Re: Newbie advice on restoring and upgrading databases

[Peter Brawley]

> 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.