I have a 2.2gb SQL dump that I need to import. I'm using the following:
mysql -u myuser -p mydb < backup-20-june.sql
Which i've used many times in the past. However this is what's happening, surely these are escaped by the dump etc?
ERROR 1064 (42000) at line 196: 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 ''A New York Review Books OriginalDeceptionâthe lies we tell ourselves and the ' at line 1
Is there a flag i'm missing, or do you have any ideas? - Thanks