database restore completed with errors
-
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: https://[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 INTOash4_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/; +https://www.askapache.com/wordpress/crazy-cache-wordpress-plugin.html)’, ‘https://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.
- The topic ‘database restore completed with errors’ is closed to new replies.