ERROR 1064 (42000): You have an error in your SQL syntax;

  • Hey all

    I have been assigned the task of moving our wordpress site to a new server – nothing else has changed (domain, etc). I’ve done this before and hadn’t had any problems but this move is proving problematic.

    The database is large so i uploaded the .sql using FTP and when I tried to import it with SSH things get weird. I must admit I haven’t had to use the SSH before so this is all new so I’m using the following article to guide me:
    https://support.godaddy.com/help/article/7588/importing-mysql-databases-via-ssh?pc_split_value=2

    When I tried the use database command I get the following error:

    ERROR 1064 (42000): 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 line 1

    Please help!

Viewing 4 replies - 1 through 4 (of 4 total)

  • How large is this database backup file? Can’t you use a db management tool like Phpmyadmin?

    Thread Starter nationbestrong

    (@nationbestrong)

    hey thanks for the quick reply! the file is 514mb. When I used phpmyadmin the browser timed out so I had to use FTP and SSH

    Have you tried cutting a copy of the backup file down into smaller chunks and carrying out multiple imports?

    Thread Starter nationbestrong

    (@nationbestrong)

    Same thing – here is the error message from trying to import in smaller chunks:

    There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
    —-BEGIN CUT—-
    eNpzDQryD7JScDZUcDZS8HH1s1IwNFQwNFIws+AKDgFKzOTi8q0MDvSxUjDVM9QzN+QKDQ5S8A/W
    UXB0d/UL0VEIcwUq8k1MVnD2CPL3dVUw1zPQM+QK8HW0UjDWM9WzAHE8AkDKdPyDQYYY6xkaKPhk
    5pVWcPk4+rlbKaTmcYHN53KKyjAxdIxUS8wtsA6OnHnp4x2GmoL/f+tLQ13q/4PBPxCOYeBQKyzN
    L7EuBqtcITGDQYAhsTCuRG7fqtVmX/Vt975fzBIg5+ymuEBC7n7lSimI6m3HThtbAwAHS08B
    —-END CUT—-
    —-BEGIN RAW—-
    ERROR: C1 C2 LEN: 11 12 68
    STR: ?

    MySQL: 5.1.71
    USR OS, AGENT, VER: Mac CHROME 7.0.1
    PMA: 3.5.8.1
    PHP VER,OS: 5.3.10 Linux
    LANG: en
    SQL:
    BZh41AY&SY????|p??uUD???????????\”s&??aq^t???6?/=???PCF!??y?”???3;
    —-END RAW—-

    SQL query:

    BZh41AY&SY????|p??uUD???????????\”s&??aq^t???6?/=???PCF!??y?”???3;

    MySQL said: Documentation

    #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 ‘BZh41AY&SY?ò?ü’ at line 1

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘ERROR 1064 (42000): You have an error in your SQL syntax;’ is closed to new replies.

Tags