Dreaded mYSQL 1064 error when importing MySQL 4 database into MySQL5
I have dumped a live site store database onto my pc to run some mods offline. I tried to import the .sql file into my XAMPP installation using phpmyadmin and all went well until the coupon_gv_customer table was being created.
the error is as follows:
my XAMPP mySQL is version 5.0.51a
#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 'Content-Type: text/html' at line 1
the webserver version is MySQL 4.1.19-standard-log (according to Zencart server info)
The webserver has a GUI control panel that is devoid of any mySQL export options so I cannot alter the fomrat in which the data is exported.
I tried importing using the MySQL v4 compatible setting but I still get the same error.
16 of the tables import just fine!
I know that there are issues when exporting and imprting to different versions of MySQL but I expected a v5 SQL to accept v4 SQL data without any problems.
I wanted to bring up the subject here first in case any mySQL gurus out there could help. Especially as many faq's and wiki docs cover reinstalling a MySQL database as if it were a benign procedure.
I don;t relish having to post this in a mySQL forum, I probably won't understand the answer.
Anybody out there with any idea on how to solve this?
[FONT=Tahoma]Proud to donate monthly[/FONT]