Friday, March 1, 2013

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

No comments:

Post a Comment