Results 1 to 8 of 8

Thread: Delete Database

  1. #1

    Question Delete Database

    Any idea how to delete a database in phpMyAdmin?
    I don't see a button to drop the database

  2. #2
    Moderator wildjokerdesign's Avatar
    Join Date
    Jun 2003
    Location
    Kansas City Mo
    Posts
    5,720

    Default

    You should have a Drop tab all the way to the right when you view a database. If you don't see that then when you are on the Home page of phpMyAdmin then click on Databases. On the resulting page you should be able to select the database you want to delete then click on the Drop icon at the bottom. Should have a big red X through it. If none of those work then simply run the following SQL statement.
    Code:
    DROP DATABASE `test`
    Replace test with the database you want to drop.
    Shawn
    Please remember your charity of choice: http://www.redcross.org

    Handy Links: wildjokerdesign.net | Plain Text Editors: EditPlus | Crimson

  3. #3
    Moderator ifurniss's Avatar
    Join Date
    Oct 2009
    Location
    Utah
    Posts
    47

    Default

    If you are in a cPanel account, you would just delete the database from cPanel >> MySQL databases rather than PHPMyAdmin. You can also delete the user if you no longer need it for any of your databases.
    Isaac Furniss
    Technical Support Team Manager
    Contact Support: E-mail | Live Chat | Twitter

    http://www.westhost.com/

  4. #4

    Default

    Quote Originally Posted by ifurniss View Post
    If you are in a cPanel account, you would just delete the database from cPanel >> MySQL databases rather than PHPMyAdmin. You can also delete the user if you no longer need it for any of your databases.
    Well I think there is a fault in cPanel.
    When I click on MySQL databases then the messages will come that there are no databases found.
    Strange because there are about 12 databases running.

    Shawn, thnak for your replay
    I don't see the button on the right, I have tried a lot of options.
    But I can run the SQL statement.
    Must I do this from the local host or must I first select the database and than run the SQL comment?

  5. #5

    Default

    It's possible that cPanel isn't seeing the databases. Generally cPanel requires the database to have the exact prefix that it specifies for it to be recognized in there. So if they were uploaded but with a different prefix, cPanel wouldn't be seeing them. I would recommend opening a ticket through your cp.westhost.com page under "Support" so we can take a look into it.
    Nathan Collings
    Level 2 Technical Support Rep

    http://www.westhost.com/

  6. #6
    Moderator wildjokerdesign's Avatar
    Join Date
    Jun 2003
    Location
    Kansas City Mo
    Posts
    5,720

    Default

    Aberg,
    Did you migrate these databases from a Sitemanager account? That is most likely the issue as Nathan has mentioned and support should be able to sort that out for you. The command I gave you would be something you run in phpMyAdmin or once you connect to mysql via localhost. No need to select a database since you are stating it in the command. I would still urge you to contact WestHost so they can get the other databases synced with cPanel. I'll just make your life easier in the future.
    Shawn
    Please remember your charity of choice: http://www.redcross.org

    Handy Links: wildjokerdesign.net | Plain Text Editors: EditPlus | Crimson

  7. #7
    Moderator ifurniss's Avatar
    Join Date
    Oct 2009
    Location
    Utah
    Posts
    47

    Default

    If a database isn't seen correctly from cPanel it can cause a lot of random errors and connectivity issues with your site applications. I highly recommend submitting a ticket to our team so we can work on getting those databases created correctly and then removing the incorrect entries from PHPMyAdmin.
    Isaac Furniss
    Technical Support Team Manager
    Contact Support: E-mail | Live Chat | Twitter

    http://www.westhost.com/

  8. #8

    Default

    Thank you but I don't send a support ticket because migration from the Sitemanager (3.0) was a hell of a job.
    I had a very good support from Westhost and they have solved a lot of problems.
    My website is working fine, but I saw there where a lot off database create. ( I think by the supportteam)
    But I can delete them with the comand as Shawn wrote.
    So I'am happy for now and I don't to make problems to ask support for the fault in the Cpanel with the database programm.
    Thank you anyway

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •