WordPress Designpraxis Forum » BackUpWordPress Issues resolved

#1064 - You have an error in your SQL syntax;

(4 posts)

Tags:


  1. tboggi
    Member

    Hello,

    while the backup i get the errormessage:

    #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 '22:38:49, '2007-07-16 22:38:49', 'cdc47d11282a7602e63b7ea100e10e4b')' at line 1

    And now ??

    My Logfile:
    WordPress Version: 2.2.1
    BackUpWordPress Version: 0.2.4
    ## 9. September 2007 22:33:40: successfully written to SQLfile: /var/www/web52/html/wp-content/backup/2007-09-09-22-33-40/wordpress.sql

    My Backup Logfile:
    Preset: sql only
    Schedule: scheduled
    WordPress Version: 2.2.1
    BackUpWordPress Version: 0.2.4
    ## 9. September 2007 22:33:40: BackUpWordPress starting at 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: BackUpWordPress using Preset sql only
    ## 9. September 2007 22:33:40: BackUpWordPress temporary Directory '/var/www/web52/html/wp-content/backup/2007-09-09-22-33-40' created
    ## 9. September 2007 22:33:40: MySQL server connected successfully 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_TABLE_STATISTICS created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_TABLE_STATISTICS_RAW created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_categories created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_comments created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_ec3_schedule created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_golfresult created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_golftable created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_link2cat created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_links created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_mygallery created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_mygprelation created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_mypictures created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_options created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_pollsa created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_pollsip created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_pollsq created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_post2cat created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_post_notification_cats created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_post_notification_emails created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_post_notification_posts created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_postmeta created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_posts created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_stp_tags created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_usermeta created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_users created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_wordtube created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_wordtube_med2play created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: sql-dump for wp_wordtube_playlist created 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: SQL Dump created.
    ## 9. September 2007 22:33:40: Archive File created/compressed successfully: /var/www/web52/html/wp-content/backup/2007-09-09-22-33-40-sql.tar.gz
    ## 9. September 2007 22:33:40: 2 Temporary Directories and Files deleted successfully
    ## 9. September 2007 22:33:40: No old BackUpWordPress Archives to delete
    ## 9. September 2007 22:33:40: No old BackUpWordPress Log Files to delete
    ## 9. September 2007 22:33:40: BackUpWordPress done at 9. September 2007 22:33:40
    ## 9. September 2007 22:33:40: BackUpWordPress was running for 0.36 Seconds

    Greetings
    tboggi

    Posted 4 years ago #

  2. rol
    Key Master

    tboggy, you BackUpWP log seems allright. Have you checked the contents of a full backup generated by BackUpWordPress? Have you tried to execute the generated dump on a mySQL server? Beware! Don't do it on a production system!!

    Posted 4 years ago #

  3. tboggi
    Member

    Yes, I extracted the gz.tar file and imported "wordpress.sql" directly on phpmyadmin in a copy of my blog-space.

    Posted 4 years ago #

  4. rol
    Key Master

    So probably everything is alright with your dump? Would you please let us know if the problem persists and/or you find a solution? Thanks in advance!

    Posted 4 years ago #

RSS feed for this topic

Reply

You must log in to post.