I would say that's because mysql thinks that "-" is subtraction and not a
hyphenation. You could try:
mysql> drop database 'planhouse-broke';
or delete the directory called 'planhouse-broke'.
and in future, I think you'll save yourself a lot of agro if you use
underscore instead.
O | O
\____/
----- Original Message -----
From: "Johnny Withers" <[EMAIL PROTECTED]>
To: "Mysql-List" <[EMAIL PROTECTED]>
Sent: Monday, March 05, 2001 23:35
Subject: Bug in MySQL 3.22 ?
> 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
---------------------------------------------------------------------
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
