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&g
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'; datab
: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
>
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 *
When you DROP DATABASE 'base', mysql drops all its tables then drops the db.
At the filesystem, this means deleting all the table files from the 'base'
subdirectory of mysql's data directory, then deleting the 'base directory
itself. If 'base' contains a file that isn't a table file, however,
Hi
I am running Suse Linux 8.2 and MySQL 3.23.55
A funny thing happens:
%> mysqladmin drop base
Database "base" dropped
%> mysqladmin create base
Can't create database 'base'. Database exists.
And if I log in to MySQL, there it is - undropped!
So why is mysqladmin telling me the database is dr
AM
To: [EMAIL PROTECTED]
Subject: can't drop database: ERROR 1217
version: mysql Ver 12.22 Distrib 4.0.18, for pc-linux (i686)
mysql> DROP DATABASE xxx;
ERROR 1217: Cannot delete or update a parent row: a foreign key
constraint fails
what is this all about? how the heck can I drop the
version: mysql Ver 12.22 Distrib 4.0.18, for pc-linux (i686)
mysql> DROP DATABASE xxx;
ERROR 1217: Cannot delete or update a parent row: a foreign key
constraint fails
what is this all about? how the heck can I drop the database?
Dean Hoover
--
MySQL General Mailing List
For list archives: ht