Re: Newbie advice on restoring and upgrading databases

[David Blomstrom]

I made a backup copy of my ONLINE databases, which were downloaded as a file with the extension sql. I haven't tried importing that into MySQL on my laptop yet.

My local databases included a lot of tables that I hadn't published online yet. I don't think I have a mysqldump backup.

As near as I can recall, MyISAM was my default table setting.

The MySQL version running on my MAMP installation is 5.7.26. I just tried importing another MYD file from my older mysql56 folder, and I got this error message:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

I discovered that if I open a MYD file that stores articles in TextEdit, I can retrieve the information easily. But if I open a file that had multiple columns of data (names, dates, etc.), it's a mess.

I never had time to figure out all the intricacies of MySQL, so my best bet would probably be to try and hire someone locally who can fix the problem for me. Is that something a pro could do in a few minutes, or would they have to open each file one at a time and work on it?

Thanks.