Upgrading MySQL

LawsHosting

Verified User
Joined
Sep 13, 2008
Messages
2,368
Location
London UK
Whenever I upgrade MySQL (even to minor versions), backups fail.... If I manually run mysql_upgrade, then restart service, all fine.....

I thought CB2 did all this....
 
Hello Peter,

Backups fail with what error? Or you don't have them created?

Code:
grep mysql_backup= /usr/local/directadmin/custombuild/options.conf


Code:
./build set mysql_backup yes

?
 
I do have backups enabled before upgrading mysql.

Normal backups fail with
"Error while backing up database xxx
mysqldump error output: mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'gtid\_mode'': Native table 'performance_schema'.'session_variables' does not exist"

after upgrading.
 
Code:
sudo mysql_upgrade -u root -p --force
sudo service mysql restart
 
Back
Top