SitePoint Sponsor

User Tag List

Results 1 to 6 of 6
  1. #1
    SitePoint Addict
    Join Date
    Jul 2004
    Location
    Brooklyn, NY
    Posts
    316
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Can't drop database

    I've successfully dropped all tables but I can't remove the database itself.
    Here's the printout from phpmyadmin:

    DROP DATABASE `mydb_generic`

    MySQL said:
    #1010 - Error dropping database (can't rmdir './mydb_generic', errno: 39)

  2. #2
    Trash Boat mkoenig's Avatar
    Join Date
    Aug 2007
    Posts
    1,232
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have you checked to see if you have permission?

    Do you have cpanel and phpmyadmin ? if so i would suggest using that GUI its scads easier.

  3. #3
    SitePoint Addict
    Join Date
    Jul 2004
    Location
    Brooklyn, NY
    Posts
    316
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes, I'm logged in as the root mysql user.
    But no, it's not a cPanel/WHM server.

  4. #4
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    look in that directory and remove any stray files.
    Check out our new Industry News forum!
    Keep up-to-date with the latest SP news in the Community Crier

    I edit the SitePoint Podcast

  5. #5
    Trash Boat mkoenig's Avatar
    Join Date
    Aug 2007
    Posts
    1,232
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Windows Server?

    If so you can still install a gui. Im running on a windows web server at work.

    try removing strays like longneck says, if that doesn't work 2x check permissions and syntax and if all else fails install a gui.

  6. #6
    SitePoint Addict
    Join Date
    Jul 2004
    Location
    Brooklyn, NY
    Posts
    316
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks longneck, that turned out to be the problem.


Bookmarks

Posting Permissions

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