Hi,
After searching posts here, I still get no solution for this error when I import my database (version: 3.23.58) for moving to another server (version: 4.1.22).
I tried different adjustments in phpMyAdmin export panel. To no avail.
Any suggestions much appreciated.
Pieter
#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 'cat_ID` bigint(20) NOT NULL auto_increment,
cat_name varchar(55) NOT NULL d' at line 1`
Well, since I got no replies, I was searching further for the solution for many hours ... and putting the solution here for other desperados.
I figured that when I downloaded the database file, there was a little square (??) for every return in the file.
When I just got it from the browser and copy/pasted into a new file, the squares where gone. Then it worked. Hmm ... I mean it didn't, because I got no tables ?! Nothing.
Again hours. Then I found that I had to remove all -- comment lines in the file. Even replacing with # did not work.
A mistery to me, but in the end it's solved.
Err .. solved? I got some question marks in my posts, instead of spaces and special characters like © and stuff. Should have to do with the MySQL 4 version which works with UTF-8 ...
Pieter