Repairing MySQL database form WHM.
You can attempt to repair MySQL databases using WebHost Manager.
Then function checks each table for errors and tempts to fix them.
To repair a database:
Click on the Repair a Database link in the MySQL menu.
Click on the database that you want to repair in the displayed list and click on the Repair Database button.
A status list is displayed, stating which tables have been checked and the result.
Setting up a remote MySQL server for cPanel/WHM server.
You can change the MySQL server from the local server (”localhost”) to point to a remote server.
This allows MySQL functions to be performed by another computer.
To set up a remote MySQL server:
1.Click on the Setup Remote MySQL server link.
2.Enter the name of the remote server in the Remote Mysql Host field and its password in the Remote Mysql Host’s Root Password field.
Note: Do not enter the root password for the remote MySQL server in the Remote Mysql Host’s Root Password field.
3.Click on the Setup button.
How to upgrade Mysql on Plesk with CentOS Linux
The procedure for upgrade of Mysql is quite simple.
wget -q -O – http://www.atomicorp.com/installers/atomic.sh | sh
How to upgrade:
yum –enablerepo=atomic-testing upgrade mysql
–enablerepo=repoidglob
Enables specific repositories by id or glob that have been disabled in the configuration file using the enabled=0 option.
To upgrade php run ‘yum upgrade php‘
With the above methods mysql will be upgraded to latest release.
Sometimes we may see the mysql database size as zero in cPanel
This can be fixed as follows: SSH to the server as root and edit the cpanel.config file
vi /var/cpanel/cpanel.config
search for
disk_usage_include_sqldbs=0
and then make change to
disk_usage_include_sqldbs=1
If the parameter is not present, add it. Save the file and execute the following command:
This may take few minutes to get fixed if you have a large number of users with databases, but once done, we should be able see the database disk usage show up accurately in cPanel.
How to fix MySQL quotas showing 0MB
If your MySQL databases are all showing 0.00MB usage, you probably don’t have the following checked in Tweak Settings:
Calculate the disk usage of account MySQL and PostgreSQL databases.
For some reason, the default setting is “disabled”, or unchecked.
