At 8:15 PM -0700 2/25/01, Geoff Coffey wrote:
>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
