WordPress.org

Ready to get started?Download WordPress

Forums

BackWPup Free - WordPress Backup Plugin
database restore completed with errors (2 posts)

  1. tcolling
    Member
    Posted 1 year ago #

    Hi - I ran a restore today after accidentally deleting my website files (arrrgghhhh...)

    Here's what happened when I ran the db restore script. What should I do to overcome this problem?

    - Tim

    Continue Script if needed: http://my blog url here]/backwpup_db_restore.php
    ................................................... and a lot more ... here...
    ERROR: BackWPup database error Duplicate entry '31307' for key 'PRIMARY' for query INSERT INTO ash4_redirection_logs ( id, created, url, sent_to, agent, referrer, redirection_id, ip, module_id, group_id )VALUES ( 31307, '2010-05-24 10:33:19', '/askapache-crazy-cache-backend.php?_wpnonce=ea8c695667', NULL, 'Mozilla/5.0 (compatible; AskApache/; +http://www.askapache.com/wordpress/crazy-cache-wordpress-plugin.html)', 'http://www.askapache.com', NULL, '74.52.59.242', 3, NULL );
    ERROR: BackWPup database error Variable 'time_zone' can't be set to the value of 'NULL' for query SET TIME_ZONE=@OLD_TIME_ZONE ;
    .
    ERROR: BackWPup database error Variable 'sql_mode' can't be set to the value of 'NULL' for query SET SQL_MODE=@OLD_SQL_MODE ;
    .
    ERROR: BackWPup database error Variable 'foreign_key_checks' can't be set to the value of 'NULL' for query SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS ;
    .
    ERROR: BackWPup database error Variable 'unique_checks' can't be set to the value of 'NULL' for query SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS ;
    .
    ERROR: BackWPup database error Variable 'character_set_client' can't be set to the value of 'NULL' for query SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT ;
    ..
    ERROR: BackWPup database error Variable 'collation_connection' can't be set to the value of 'NULL' for query SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION ;
    .
    ERROR: BackWPup database error Variable 'sql_notes' can't be set to the value of 'NULL' for query SET SQL_NOTES=@OLD_SQL_NOTES ;
    .
    410737 Database Querys done.
    Make changes for blogurl and ABSPATH in database if needed.
    Restore Done. Please delete the SQL file and this script.

    http://wordpress.org/extend/plugins/backwpup/

  2. Daniel Hüsken
    Member
    Plugin Author

    Posted 1 year ago #

    On Duplicate Keys i can't do anithing. Tht kames bevore the backup or u have had warrnig on the backup.

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic