I just installed mysql 3.23 and then ran a script to create a database I had
previously been using in an older version. I have a couple questions.
First, how can I make a drop database statement not fail if the database
doesn't exist. A book I was using seemed to say:
drop database dbname if exists;
Would work, but I get an error with this. What is the correct syntax?
Second, on this newest installation, I can't drop a database. I get the
error "failed to rmdir ./dbname, errno 21" or something similar. If I su to
my mysql user, and cd to the data directory, an rmdir dbname works
successfully, so I'm not sure why this is failing. The actual data files in
the database are all gone after the drop statement. Only the empty directory
sticks around.
Any help would be appreciated.
Thanks,
Geoff
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
