One of my servers is beginning to show signs of failure, so I am creating a document to recreate that server. In a nutshell, here is what I tried and ran into errors.
- Install minimum OS (Centos server)
- Restore system backup
- Restore vbackup (virtual hosts file)
I am getting errors and incomplete restore at this point. I am using Virtualmin Backup/Restore option. The problem is with information_schema db. If I exclude a restore of the mySQL db the restore is successful.
If I include the mySQL db I get an error: Restore failed : SQL drop database
information_schema failed : Access denied for user ‘root’@‘localhost’ to database ‘information_schema’
The work around is to uncheck the restore for mySQL db. Then manually create each db and restore the tables into the db using the individual sql backup files created with the mysql backup script.
Any help or guidance is certainly appreciated.
I failed to note the versions.
Operating system CentOS Linux 5.4
Webmin version 1.500
Virtualmin version 3.76.gpl GPL
So you only run into that while restoring a database? You don’t see any errors while backing it up?
Can you verify that in Webmin -> Servers -> MySQL -> Change Admin Password, that the current MySQL root password is correct?
I can find no problems with the backup and no errors in the logs.
I did verify that the mysql root password is correct and matches on both the old system and the new system.
The problem seems to be with a “drop” of the information_schema. The backup says information_schema was backed up by the primary domain user, but you would think root should be able to restore it.
I can blow away this installation and start over with a step-by-step if it will help to resolve this. I don’t feel like the backup/restore plan is complete unless the restore goes without errors.
I’m having this exact same problem. If anyone’s figured it out, I’d be extremely appreciative.