I've successfully dropped all tables but I can't remove the database itself.
Here's the printout from phpmyadmin:
1010 - Error dropping database (can't rmdir './mydb_generic', errno: 39)
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.
Yes, I'm logged in as the root mysql user.
But no, it's not a cPanel/WHM server.
look in that directory and remove any stray files.
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.
Thanks longneck, that turned out to be the problem.
This topic is now archived. It is frozen and cannot be changed in any way.