How to Delete MySQL databases via. SSH ?

[Phnx]

Hi there,

I have a cPanel hosting account with you.
I am looking for a way for deleting MySQL database using SSH. (Now,thats simple,I know) but, I wish to delete only some specific database within it with its tables.

Can somebody please suggest me how to proceed doing that?

Thanks.

[Rock]

Hi there,

I have a cPanel hosting account with you.
I am looking for a way for deleting MySQL database using SSH. (Now,thats simple,I know) but, I wish to delete only some specific database within it with its tables.

Can somebody please suggest me how to proceed doing that?

Thanks.

DROP DATABASE drops all tables in the database & deletes the database. You need to execute "drop database DBNAME;" command at MySQL command prompt to get what you wanted to do..

[Phnx]

Well, thats a pretty quick response. Thanks a lot Rock !!

But, do I need to stop the database before deleting the file? I hope it doesn't generate any errors when I restart the Db.

[Rock]

Well, thats a pretty quick response. Thanks a lot Rock !!

But, do I need to stop the database before deleting the file? I hope it doesn't generate any errors when I restart the Db.

You're welcome There's no need to stop the database or the server before deleting this DB.. no errors are to be noticed