cPanel 11.28, Database Mapping benefits
1. Accounts transferred from non-cPanel servers, such as those running Plesk or Ensim, will no longer have the cPanel account name added as a prefix to the names of databases and database users. This means applications like blogs and forums should work with minimal (or no) changes after transfer.
2. Server owners can disable use of the database name prefix server-wide. If a server owner chooses this option, databases and database users will no longer be created with the cPanel account as a prefix (for example, a database could be named “dbase” instead of “user_dbase”). This option is not reversible.
Reference: http://cpanel.net/
How can I hide information_schema database from phpMyAdmin?
By default, phpMyAdmin shows all databases available to a user. So, in addition to the databases that belong to the user, the information_schema database is also visible to them.
To hide the information_schema database from phpMyAdmin on a particular MySQL logical server, add the following line to the phpMyAdmin config.inc.php file:
$cfg['Servers'][$i]['hide_db'] = ‘information_schema’;
Please note that this affects only phpMyAdmin, and users will still be able to use the information_schema database from other applications (for example, from the mysql command-line client).
How do I import a Database using PhpMyAdmin in Cpanel
To import we will need the file in .sql format, not compressed .zip or .tar.gz file.
Log into your CPanel and find the link for PhpMyAdmin.
Once in PhpMyAdmin you will see on the left side a drop down of the databases, select the database you would like to import to.
This will create some tabs at the top of the screen, click on SQL.
After clicking on SQL you will see a Text Box area and a file upload option.
Click browse on the file upload option and find your .sql file
After you have selected the file click GO and it will import your database to the server.
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 :
