Richard Jones' Log: Argh, MySQL paaain
Mon, 01 Mar 2004
MySQL really, really shits me sometimes. My latest:
[root@richardpc root]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 to server version: 4.0.16-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> drop database rounduptest; Query OK, 0 rows affected (0.00 sec) mysql> commit; Query OK, 0 rows affected (0.00 sec) mysql> Bye [root@richardpc root]# mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 to server version: 4.0.16-Max Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database rounduptest; ERROR 1007: Can't create database 'rounduptest'. Database exists mysql> Bye
So until I can figure how to get rid of that database, my unit tests use "rounduptest2" for testing. Grr.
Ian, you rock! :)
Show MySQL who's boss!
$ su -
# /etc/init.d/mysqld stop
# rm -rf /var/lib/mysql/rounduptest
# /etc/init.d/mysqld start