MySQL

From GLMWiki
Revision as of 10:08, 8 November 2018 by Kc8wxm (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

After an update to mysql 5.7.23 I would get errors when trying to use mysqldump command.

Couldn't execute 'SHOW VARIABLES LIKE 'gtid\_mode: Native table 'performance_schema'.'session_variables' has the wrong structure (1682)

I had to run a mysql_upgrade command

mysql_upgrade -uroot -p{yourpassword} 

It takes a while if you have a lot of databases.


Restart your mysql server.


mysqldump should work again.