[EMAIL PROTECTED] wrote:
>
> After I've dropped the database using mysqladmin, the
> following message appeared:
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> %mysqladmin drop databasename
> 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 databasename database [y/N] Y
> Database "databasename" dropped
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> However when I wanted to create a new database with the same
> name, it said that the database still exist
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> %mysqladmin create MRP
> mysqladmin: CREATE DATABASE failed; error: 'Can't create
> database 'databasename'. Database exists'
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> Have I did something wrong?
>
> Best Regards,
> Dennis
>
Dennis:
Are there files in the database directory? Remove them.
In the directory that holds your dbs:
rm -Rf databasename
Van
--
=================================================================
Linux rocks!!! http://www.dedserius.com/
=================================================================
---------------------------------------------------------------------
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