MySQL Forums
Forum List  »  Data Recovery

Re: Newbie advice on restoring and upgrading databases
Posted by: David Blomstrom
Date: August 01, 2020 11:13AM

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?


Options: ReplyQuote

Written By
Re: Newbie advice on restoring and upgrading databases
August 01, 2020 11:13AM

Sorry, you can't reply to this topic. It has been closed.

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.