the following is quite odd, maybe i'm doing something wrong..
mysql> drop database planhouse-broke;
ERROR 1064: You have an error in your SQL syntax near '-broke' at line 1
mysql> show databases;
+-----------------+
| Database |
+-----------------+
| jeffdavis |
| kermit |
| kite |
| mediabankDEMO |
| mysql |
| planhouse |
| planhouse-broke |
| portal |
| rivoaks |
| test |
+-----------------+
10 rows in set (0.00 sec)
mysql> use planhouse-broke;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
Didn't find any fields in table 'accentorderdetail'
Didn't find any fields in table 'accentordermain'
Didn't find any fields in table 'accents'
Didn't find any fields in table 'articlecats'
Didn't find any fields in table 'articles'
Didn't find any fields in table 'articletypes'
Didn't find any fields in table 'artisans'
Didn't find any fields in table 'bannercats'
Didn't find any fields in table 'banners'
Didn't find any fields in table 'bannertypes'
Didn't find any fields in table 'cart'
Didn't find any fields in table 'companylist'
Didn't find any fields in table 'designers'
Didn't find any fields in table 'layout'
Didn't find any fields in table 'maincats'
Didn't find any fields in table 'mainminiweb'
Didn't find any fields in table 'mainsubcats'
Didn't find any fields in table 'members'
Didn't find any fields in table 'planner'
Didn't find any fields in table 'plans'
Didn't find any fields in table 'planstyles'
Didn't find any fields in table 'pricegroup'
Didn't find any fields in table 'siccodes'
Didn't find any fields in table 'specials'
Didn't find any fields in table 'subcatsicbond'
Didn't find any fields in table 'supplier'
Didn't find any fields in table 'suppliersiclink'
Didn't find any fields in table 'users'
Didn't find any fields in table 'webstyle'
Didn't find any fields in table 'zipcodeplans'
Didn't find any fields in table 'zipcodes'
Database changed
mysql> show tables;
+---------------------------+
| Tables in planhouse-broke |
+---------------------------+
<--- table list --->
mysql>exit;
[root@host:mysql]# mysqladmin -u root -p drop planhouse-broke
Enter password:
Dropping the database is potentially a very bad thing to do.
Any data stored in the database will be destroyed.
Do you really want to drop the 'planhouse-broke' database [y/N]
y
mysqladmin: drop of 'planhouse-broke' failed;
error: 'Error dropping database (can't rmdir './planhouse-broke', errno: 39)'
[root@host:mysql]# perror 39
Directory not empty
--------------
It seems I can not drop the database using the MySQL commands (neither from the client
or from an external MySQL program). However,
I can simply bring mySQL down and rm -rf the 'planhouse-broke' dir and restart MySQL.
Seems to me there is something wrong though.
---------------------
Johnny Withers
[EMAIL PROTECTED]
p. 601.853.0211
c. 601.954.9133
---------------------------------------------------------------------
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
