Phantom DB Cannot Be Removed
AnsweredAlma v8.10.0 Standard
WHM 120.0.11
Hi, All,
Having an issue with a phantom mariadb database that had been deleted some time back.
It is affecting the database backup portion of Jet as the logs show "unknown database", causing the backup to show as "partially completed."
Neither PHPMyAdmin in WHM nor a CLI session as root to the SQL client show the database to be in existence, yet if I go into "Manage Databases" in WHM it's there, but can only be renamed, not deleted.
Have rebooted WHM, and it still shows up in "Manage Databases".
Why does WHM "think" the database exists, and how do I get its spurious listing removed?
-
Hi,
Normally, you should have the option to delete the database from cPanel > MySQL Databases in this situation, even if the database does not exist in MySQL. We have an article below detailing this workaround:
How-to resolve “mysqldump: Got error: 1049: Unknown database“ errors during the WHM backup
If you do not have the option to delete the database in the MySQL Database interface, rebuilding the database map for the cPanel user would be another option. This issue is usually is caused when a database is manually removed in an unsupported manner. This would cause the database to still exist in the cPanel user's database map but not in MySQL. The following article details how-to rebuild the user's database map:
How to rebuild a cPanel user's database map
0 -
'k, thanks, it was still showing up in the user's panel, but for some reason not in WHM...
0
Please sign in to leave a comment.
Comments
2 comments