UnixServerAdmin

Server Administration & Management

MySQL Databases & Users Missing from cPanel

After upgrading to cPanel 11.2x, Many users indicated that their databases were missing from their cPanels, despite the actual databases existing on the server.  There are a number of things that can cause this, including corrupted Perl modules and MySQL not running, but the major cause that the new database mapping functionality.  As we know, cPanel has vastly improved their migration capabilities by recently changing how databases are mapped to user accounts, now allowing database names without user prefixes.  However, this seems to cause an issue when databases exist on the server with invalid names.

Check /var/lib/mysql directory and see if you maybe have folders in there named incorrectly. On one of my servers, the admin renamed several of the databases to $dbname.bak when making changes, and when the database quota script ran it was erroring out. After you move or remove these directory, run the following script :-

#/scripts/update_db_cache

Assuming we’ve removed all the invalid databases from the MySQL folder.

Advertisements

January 9, 2011 Posted by | cPanel, MySQL | , , | 2 Comments