Cannot take BackUps - Help Please

Help! (Home for newbies)
1

Hi there,

I am in process of moving my all sites from old virtualmin to a new hosting with fresh virtualmin installation

When i tried to take backup using the Back Up Virtual Server option it gave me following error
mysqldump: Couldn’t execute ‘SHOW FUNCTION STATUS WHERE Db = ‘dbname’’: Cannot load from mysql.proc. The table is probably corrupted (1548)

I searched about that error and foudn out that I have to upgrade mysql with command mysql_upgrade

I tried to use this command in Manage Database > Execute MYSQL but it gave me following error

Failed to execute SQL : SQL mysql_upgrade failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘mysql_upgrade’ at line 1

My virtualmin version = 5.0
I also have two php version on this server

Any help is really appreciated.

2

Howdy,

Hmm, what distro/version is it that you’re using there? And what MySQL version?

And have you been able to make backups in the past?

Lastly, was a MySQL upgrade attempted on your server? The error you’re receiving seems to suggest that an upgrade to a different MySQL version may have been attempted.

-Eric

3

hi eric,

I am using CentOS Linux 6.6 64
I have never taken backups in the past. I tried to use the upgrade attempt using execute SQL option.

4

any update?

5

You mentioned this:

I tried to use the upgrade attempt using execute SQL option.

I’m not sure I follow there – can you describe what you mean by that?

Also, what is the output of this command:

rpm -qa | grep mysql

6

here is the result of command

compat-mysql51-5.1.54-1.el6.remi.x86_64
mysql-server-5.5.47-1.el6.remi.x86_64
mysql-libs-5.5.47-1.el6.remi.x86_64
mysql-devel-5.5.47-1.el6.remi.x86_64
php-mysql-5.4.45-3.el6.remi.x86_64
mysql-5.5.47-1.el6.remi.x86_64

I am using 2 php version on this server

i mean i went to SERVER > EDIT DATABASE > MANAGE > EXECUTE SQL > ““COMMAND””