It looks like you didn't drop anything. Linux & Unix software (unless it's written to be case-insensitive) is always case sensitive. So typo and TYPO are not the same.
You want to 'drop database TYPO'. On 6/12/06, Hal Fulton <[EMAIL PROTECTED]> wrote: > OK, I did a 'drop database'... it seemed to work. > > Should I have dropped all the tables first?? > > Anyway, if I try to drop it again, it tells me > it can't drop it, it doesn't exist. > > If I try to restore my database (which first of all > does a 'create database') it tells me it can't > create it, it already exists. > > Sigh. > > Any ideas? > > > Hal > > > [EMAIL PROTECTED] typo]# mysql > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 32 to server version: 4.1.13-standard > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> drop database typo; > ERROR 1008: Can't drop database 'typo'; database doesn't exist > mysql> commit; > Query OK, 0 rows affected (0.00 sec) > > mysql> quit > Bye > [EMAIL PROTECTED] typo]# mysql <backup3.out > ERROR 1007 at line 1: Can't create database 'TYPO'; database exists > [EMAIL PROTECTED] typo]# > > _______________________________________________ > Typo-list mailing list > [email protected] > http://rubyforge.org/mailman/listinfo/typo-list > -- Man Wit Da Plan. http://d-jacobs.com _______________________________________________ Typo-list mailing list [email protected] http://rubyforge.org/mailman/listinfo/typo-list
