a similar problem happened to me and I got the error:
ERROR 1051: Unknown table '#sql-ffa_2,#sql-2b2_30'
After reading your post, I checked in the data directory and there are two files there, both of file type data:
#sql-2b2_30.frm #sql-ffa_2.frm
I certainly didn't put them there myself - I think they must have come from mySQL automatically at some point.
Are they real tables in the database? I can't see them when I use 'show tables'. Is it a permissions problem? I have this on another database that I was trying to restore from a dump. I had to rename the database in the end.
I am using InnoDB tables for some of my data.
Regards Adam
On 10/01/2003 09:09 AM Heikki Tuuri wrote:
Feng,
do you have some non-MySQL file in that database directory under the datadir of MySQL?
Naturally, MySQL will not drop the directory if it contains something more than just MySQL tables.
Best regards,
Heikki Tuuri Innobase Oy http://www.innodb.com Foreign keys, transactions, and row level locking for MySQL InnoDB Hot Backup - a hot backup tool for MySQL
Order MySQL technical support from https://order.mysql.com/
----- Original Message ----- From: ""Wang Feng"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Wednesday, October 01, 2003 8:37 AM
Subject: Re: can NOT drop the database
Not at all!!
after I typed the 'drop database my_account_database', I got the following message:
Query OK, 0 rows affected (0.00sec).
and I do the 'show databases', that one is still there.
cheers,
feng
----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 01, 2003 3:31 PM Subject: Re: can NOT drop the database
no permissions errors ?
Greetings,
I have a database called 'my_account_database' and I tried to drop it by the command 'drop database my_account_database', it doesn't work. The database is still there, can not be dropped although the tables contained in the database have gone.
I subsequently created another 2 databases and could drop them successfully.
Tried the 'drop database my_account_database' again before sending
this
message, still doesn't work.
So, what could be the problem? Have you seen this situation before?
btw, I can't find out any command which can be used to simply rename a database, please advise!!
cheers,
feng
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
-- Running mySQL 4.1.0 on Linux 2.4.20 RH9
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]