that just doesn’t sound right, does it. I just now noticed it when I ran my cron backup manually. Complete error is:
mysqldump: Couldn’t execute ‘SHOW FUNCTION STATUS WHERE Db = ‘your-db-here”: Column count of mysql.proc is wrong. Expected 20, found 16. Created with MySQL 50077, now running 50152. Please use mysql_upgrade to fix this error. (1558)
so I ran mysql_upgrade , errored about password, then I ran mysql_upgrade -p and all was ok. Well, at least from the script point of view.
Running the backup again revealed another error:
Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)
Reading about it on the net, somebody suggested a mysql restart after running the mysql_upgrade script adn what do you know, it did it.
Do note that you need to be logged as root for that command line to work. Otherwise, make sure to specify root user in the command line.
One thing that I did notice a while ago was that the “all” backup (which dumps all tables) was failing, but I didn’t give it too much attention since the per-table backups were ok. Seems this upgrade thing solved that issue as well.
This one was simple 🙂
Thank you so much for this! I was trying to perform a data transfer from one host to another and encountered the exact same problem.
I also needed to specify a user with the password:
> mysql_upgrade -u admin_larry -p;
then…
> service mysqld restart
and all is well 🙂
Thank you very much for your blog.You saved my valuable time to get resolve this issue as I am not able to take backup of any of my data bases.
all working charm now
I had this problem for months untill I decide to look on google for it and your solution works perfect! Thank you
To fix this, run the following on the server’s command line.
srv # mysql_upgrade -h localhost -u root -p
# For Plesk environments
srv # mysql_upgrade -h localhost -u admin -p`cat /etc/psa/.psa.shadow
Thank you for this solution. It works great. I was having the same problem.
So I tried running this… and I get an error:
mysql_upgrade -h localhost -u root -p
Enter password:
Looking for ‘mysql’ as: mysql
Looking for ‘mysqlcheck’ as: mysqlcheck
sh: -c: line 0: unexpected EOF while looking for matching `”
sh: -c: line 1: syntax error: unexpected end of file
Running ‘mysqlcheck’ with connection arguments: ‘–host=localhost’
sh: -c: line 0: unexpected EOF while looking for matching `”
sh: -c: line 1: syntax error: unexpected end of file
FATAL ERROR: Upgrade failed
looking over some google search results, the most probable cause would be that you have mysql fed from multiple repositories. You will have to somehow undo updates from the alien repos and then try again.
Other than that, no clue what could cause it. If that doesn’t work, hit the mysql forum maybe you get luckier 😉
Hi,
-bash: mysql_upgrade: command not found
can I do that?
Do you have mysql installed? if so, maybe it’s a path issue. Normally, that application should be in /usr/bin/mysql_upgrade
Initial time I down loaded the plugin, it all worked effectively with all
the two people I picked to check it appearing while
in the person index. I then made a couple of changes and now I don’t get these details, just a message which says This can be
somewhat embarrassing, is not it?’ . The details are there, as
I can find people via the search alternative.Secondly the marriage
details of my chosen folks don’t appear, but birth, death and other facts do.
What do I need to do to rectify these errors?
I have no idea what you mean. You should refer to the support page of the script/library you are using.
I just upgraded yesterday night from MySQL 5.5 (5.5.34-0ubuntu0.12.04.1) on Ubuntu 12.04 to MariaDB 5.5 (5.5.34+maria-1) and got this error this morning when my automatic backup script (automysqlbackup) ran.
mysqldump: Couldn’t execute ‘SELECT /*!40001 SQL_NO_CACHE */ * FROM `EVENTS`’: Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)
mysqldump: Couldn’t execute ‘show events’: Cannot proceed because system tables used by Event Scheduler were found damaged at server start (1577)…
I did mysql_upgrade with –force and restarted the mysql server but no effect, still the same error, when I try to SELECT the events table in information_schema.
Is there some other solution to this?
Thank you.
frank
I’m afraid this could be something related to MariaDB. This is the first time I read about this DB and on mariadb.com I see there are plenty of incompatibilities between it and mysql. I’d go onto their support forums for help with this one.
Thanks a lot, I will write to their mailinglist.
franks
Late later I can tell how this problem was solved: just by a restart the server!
I had beside of above problem the syslog filled with crash messages and restart of mariadb and after a restart all went good.
Easy as this 🙂
frank
Good one Frank. Thanks for sharing 😉
Where should I put mysql_upgrade script for running? Could you please provide a link where I can download right mysql_upgrade script and lounch it to upgrade from MySQL 50051 up to 50151?
you don’t put it anywhere. After you have upgraded your mysql to the new version, you have it installed in /usr/bin/mysql_upgrade and simply run it (/usr/bin should already be in your $PATH if not, just execute it as absolute path /usr/bin/mysql_upgrade )
Thanks for such swift response! I try fix it, but still I haven’t success. Anyway thanks!
well, if you get an error you have to copy-paste the entire error as you see it to me, otherwise there isn’t much I can do for you.