This problem actually started after I moved the datadir to another
folder, so that's quite possible. We stopped everything, rsynced the
folders over, then restarted mysql. But I do notice a permissions
problem, since the owner currently is root. I'll chown it to mysql
then see what happens.
I'll p
Hi,
On Sat, Mar 8, 2008 at 6:58 AM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> SHOW DATABASES; shows that I have a database called "test", but when I
> call "DROP DATABASE test", I get
>
> ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist
>
> When I run any queries on that data
Waynn:
What user are you using to execute mysql from the command line? Perhaps run
mysql (from command line) as root then execute the desired actions (such as
drop). This will make sure you can drop the table and avoid any further
problems.
Sincerely,
Craig Huffstetler
On Sat, Mar 8, 2008 at 6:
Waynn-
does the OS user you use to execute mysql have create/write/read/execute
rights to the ./test folder?
Martin-
- Original Message -
From: "Waynn Lue" <[EMAIL PROTECTED]>
To:
Sent: Saturday, March 08, 2008 6:58 AM
Subject: Can't drop database that shows
SHOW DATABASES; shows that I have a database called "test", but when I
call "DROP DATABASE test", I get
ERROR 1008 (HY000): Can't drop database 'test'; database doesn't exist
When I run any queries on that database, I get errors like:
mysql> select * from Users;
ERROR 1017 (HY000): Can't find fi
