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.
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
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.
any update?
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
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""