Import database error 1064 ?

  • Resolved Pieter

    (@pieter)


    16 years, 9 months ago

    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`

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter Pieter

    (@pieter)

    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.

    Thread Starter Pieter

    (@pieter)

    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 …

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Import database error 1064 ?’ is closed to new replies.