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.
Exim started generating error message in /var/log/exim_mainlog after update.
ACL: ratelimit database not available
The cause for this issue is exim cache database might be corrupted. To fix this error the exim cache database on the server needs to be remove(Exim rebuilds this database again after exim restart)
To fix this run the following command as root to remove the cache database.
rm -fv /var/spool/exim/db/*
Then restart the exim :
How to reconfigure and change status for domain in plesk database.
Reconfigure Domain:
/usr/local/psa/admin/sbin/websrvmng –reconfigure-vhost –vhost-name=domain.com
Change the status for domain:
/usr/local/psa/bin/domain -u domain.com -status enabled
You should get a message the Object successfully enabled, once that is done the domain should be unsuspended in Plesk.
How to access psa database in Plesk Server
We can access plesk psa database, from the Linux command line (via ssh) and from the Plesk control panel.
The /etc/psa/.psa.shadow file contains the Plesk admin password.
So to access the database run the following command.
mysql -uadmin -p`cat /etc/psa/.psa.shadow`
Select the psa database.
To view all the tables
MySQL database does not work and returns “Can’t create/write to file” error
The problem is related to the mysql directory permission.
‘mysql’ user is not able to create a temporary file in /var/lib/mysql/ directory due to permissions lack
# ls -lda ~mysql/
drwxr-xr-x 5 root mysql 4096 Aug 31 09:56 /var/lib/mysql/
The solution is to go to /etc/init.d/mysqld_app_init file and change
chown root.mysql /var/lib/mysql
to
chown mysql.mysql /var/lib/mysql
Then restart mysqld service or just change owner of /var/lib/mysql directory to “mysql” instead of “root”
chown root /var/lib/mysql
