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 »

  1. Your skill to communicate this sort of information is precisely what many of us want. By revealing your knowledge you guide people via expressing your very own information. And I’ll let you know right now your writing served me.

    Comment by fresh water | June 15, 2011 | Reply

  2. Your knowledge truly fills a need. I have been trying to come across this type of blog and you really came through. Can you imagine that what you have written just about specifically duplicates my own experience.

    Comment by filtered water | June 16, 2011 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: