Announcement

Collapse
No announcement yet.

How to Delete MySQL databases via. SSH ?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to Delete MySQL databases via. SSH ?

    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.

  • #2
    Originally posted by Phnx View Post
    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..
    Rock _a.k.a._ Jack Daniel

    Follow eUKhost on Twitter || Join eUKhost Community on Facebook

    Comment


    • #3
      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.

      Comment


      • #4
        Originally posted by Phnx View Post
        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
        Rock _a.k.a._ Jack Daniel

        Follow eUKhost on Twitter || Join eUKhost Community on Facebook

        Comment

        Working...
        X