DB not Listed in Cpanel after Mysql upgrade

When mysql is upgraded, the DB cache and dbusermap in cpanel may be lost. We need to recreate that

/usr/local/cpanel/bin/setupdbmap –> To recreate the dbusermap

/scripts/update_db_cache –> To recreate DB cache

If these do not work with the existing DB cache, move the existing db cache and run these script, it will create the cache automatically

mv /var/cpanel/databases /var/cpanel/databases.old and then run these in order /usr/local/cpanel/bin/setupdbmap /scripts/update_db_cache

Advertisements
  1. No trackbacks yet.

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: