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.

Comment by Ian Bicking on Mon, 01 Mar 2004

Show MySQL who's boss!


$ su -

# /etc/init.d/mysqld stop

# rm -rf /var/lib/mysql/rounduptest

# /etc/init.d/mysqld start


Comment by Richard on Mon, 01 Mar 2004

Ian, you rock! :)