MySQL Forums
Forum List  »  Data Recovery

Restoring a mysql db
Posted by: Gabriele Z
Date: September 20, 2019 07:30AM

Hi,
I was given a mysql db dump ( .sql file) to be restored on a new host, but when I try to import it via phpmyadmin I get an error:

#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 'acciaio al mondo [...]

Of course there's a ' next to acciaio that disrupts the import. I fix it, the next text with an ' would break it again. File is 38K+ lines long, so manually parsing everything is a very daunting task.

There's a way - after they've exported the db without "escaping" (don't know proper term, sorry) apostrophes - to fix it without manually parsing it?

Hope I have explained myself, not sure I know proper terminology. Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Restoring a mysql db
896
September 20, 2019 07:30AM
441
September 20, 2019 09:45AM


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.