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: 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 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/; +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.
The topic ‘database restore completed with errors’ is closed to new replies.