Hello,
I have a question about dropping MySQL databases. I backup my databases using the following command:
mysqldump db_name | gzip > db_name.gz
I can scp the file to another server (Server B) and restore the database by executing the following 2 commands:
mysqladmin create db_name
gunzip < db_name.gz | mysql db_name
If I drop the database on Server B, the following message is displayed:
Database "db_name" dropped
But the database still shows up when I issue the following command:
mysqlshow
So my question is, why isnt the database being dropped?