Errors during restore
rene_w - March 12, 2008 - 01:24
| Project: | Backup and Migrate |
| Version: | 5.x-1.0 |
| Component: | Code |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
I've recently tried to restore a db from a scheduled backup. It seems ok, but the log file contains three consecutive error messages from backup&migrate:
Unknown system variable 'CHARACTER_SET_RESULTS' query: SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS; in /drupal-5.7/includes/database.mysql.inc on line 172.
Unknown system variable 'CHARACTER_SET_CLIENT' query: SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT; in /drupal-5.7/includes/database.mysql.inc on line 172.
Unknown system variable 'COLLATION_CONNECTION' query: SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION; in /drupal-5.7/includes/database.mysql.inc on line 172.Any ideas?
#1
These are some instructions I'm adding to the top and bottom of each backup file to ensure that if you use the files to restore using phpmyadmin or the command line mysql file, the connection will get set to UTF-8 so that there aren't character encoding problems. They shouldn't be necessary if you're using the backup and migrate module, and as far as I know, they won't do any harm if they're failing.
That said it's a little perturbing to have them triggering errors. I'll look into mitigating this, and see if I can do any research on whether this could be a bigger issue.
What version of MySQL are you using?
thanks
R
#2
Thanks for looking into this. I'm on MySQL 4.0.24 (debian).
#3
Sorry it took so long to get to this.
I've added some conditional comments around the offending statements, which should quite the log noise for MySQL 4.0 users. I do not have a running copy of that version of MySQL to test against, so if anybody using that version is still seeing issue, please reopen this issue.
#4
Automatically closed -- issue fixed for two weeks with no activity.