SQL query error when importing database backup

  • Resolved Christiaan

    (@christiaan)


    16 years, 10 months ago

    I’ve dropped all my tables and was trying to re-import my database backup but I get the following error:

    Error
    SQL query:

    #
    # Data contents of table wp_email_list
    #
    INSERT INTO wp_email_list
    VALUES ( 1, ‘[email protected]’, 1, 2005 -04 -3008 :10 :12, ‘2005-04-30 08:10:12’ ) ;

    MySQL said:

    #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 ’08:10:12, ‘2005-04-30 08:10:12′)’ at line 1

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

    (@christiaan)

    Turns out the WordPress Database Backup plugin definitely did not use correct syntax when backing up. Had to manually add some single quotes.

    Pays to stick with phpMyAdmin it seems.

    Hi Christiann,

    I’m getting the same problem when trying to import my backup into an empty database:

    SQL query:
    #
    # Data contents of table wp_categories
    #
    INSERT INTO wp_categories
    VALUES ( 1, ‘Uncategorized’, ‘uncategorized’, ‘, 0, 0, 0, 0, 0) ;
    INSERT INTO wp_categories VALUES (2, ‘Unusual ‘, ‘unusual ‘, ‘, 0, 2, 0, 0, 0 ) ;
    MySQL said:
    #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 ‘Unusual’, ‘unusual’, ‘, 0, 2, 0, 0, 0)’ at line 1

    I’m using Version 1.7 of database backup, phpMyAdmin 2.9.0 and WordPress 2.1.3. What software did you use to add the single quotes to your database backup and where are they placed?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘SQL query error when importing database backup’ is closed to new replies.

Tags