Virtual servers backup fails at MySQL dump

5 posts / 0 new

Topic locked

Last post

#1 Wed, 04/22/2015 - 23:04

jonas-2

Virtual servers backup fails at MySQL dump

Hi,

In virtualmin I click on Backup & Restore -> Back up Virtual Servers

I leave everything in their default values and click on Backup Now button

The process starts and right at MySQLdump, it throws this error:

mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'db_name'': Cannot load from mysql.proc. The table is probably corrupted (1548)

Note: the table is not corrupted. When I do a manual 'mysqldump' in terminal, dump works as expected with no errors.

Thanks for your help.

#2 Thu, 04/23/2015 - 09:54

andreychek

Howdy,

Virtualmin just runs the "mysqldump" command and returns the output it produced.

It's possible what's happening is that the exact command being used is different, so when you ran it on the command line, it didn't trigger the problem that was produced during the backups.

What distro/version is it that you're using?

And was the MySQL version upgraded recently?

Lastly, what is the output of this command:

mysql -V

The issue you're seeing can sometimes occur when upgrading to certain MySQL versions.

#3 Thu, 04/23/2015 - 16:41

jonas-2

Howdy back :o)

mysql -V returns: mysql Ver 14.14 Distrib 5.5.43, for Linux (x86_64) using readline 5.1

Linux distro is: CentOS 6.6 (64bits)

I upgraded mysql to the above version during server initial setup. However, I never tried to do Virtual Server Backup since (roughly 2 weeks ago).

In /etc/webmin/mysql/config I have: login=root

I would like to mention that I have few virtual servers on this system and the Virtual Server Backup goes through fine for 2 servers and then hits the error on the 3rd one which happens to be a Wordpress website. If I exclude it, the backup will continue and stops again at the next Wordpress site. I don't believe this common denominator is the culprit but I figured I'd mention it.

#4 Thu, 04/23/2015 - 17:08

andreychek

Howdy,

Ah, yeah, the MySQL version you're using there doesn't come standard with CentOS 6.

I suspect the issue you're seeing is related to the change to the non-standard MySQL version.

You can see a number of similar issues come up when Googling your particular error message, one such post is here:

https://ma.ttias.be/mysql-show-function-status-where-db-name-cannot-load...

The usual solution is to run the "mysql_upgrade" command, which handles upgrading MySQL from one major version to another.

-Eric

#5 Thu, 04/23/2015 - 17:24

jonas-2

Thanks Eric! Now that I dug deeper in my rusty memory, those 2 Wordpress sites were migrated in right before I upgraded MySQL. The solution provided in the link you mentioned makes perfect sense in my case.

Topic locked