Removing a MySQL database that contains a period in it – cPanel

Sometimes you may come across a database that contains a period in the name.  This will cause you problems when trying to move the customers site to another server.  This database will not be removable from within cPanel itself.  to remove it, do the following:

Example database name (mydatabase.out)
Example Customer cPanel username (mycustomer)

1. SSH to the server
2. cd ~mysql  OR cd /var/lib/mysql
3. rm -f mydatabase.out
4. vi /var/cpanel/databases/mycustomer.yaml
5. remove any entry relating to mydatabase.out from this file
6. save the file

This database should no longer show up in the cpanel, or cause you any issues when trying to move the site to a new server.