'drop database' failing silently?

2004-05-05 Thread Kevin O' Riordan
Hi all, this morning, I had a problem dropping a database from within mysql. mysql drop database mis; Query OK, 0 rows affected (0.00 sec) mysql show databases; +--+ | Database | +--+ | mis | | mysql| +--+ 2 rows in

Re: 'drop database' failing silently?

2004-05-05 Thread Kevin O' Riordan
this morning, I had a problem dropping a database from within mysql. Are there any non-mysql files in the directory of the database 'mis'? Should've added this. There was only one file in the 'mis' directory: -rw-rw-rw-1 mysqlmysql 44 Apr 30 09:51 file.out Which

Re: 'drop database' failing silently? - solved.

2004-05-05 Thread Kevin O' Riordan
this morning, I had a problem dropping a database from within mysql. [snip] The solution I used was to stop mysqld and then rm the database from the filesystem. Are there any non-mysql files in the directory of the database 'mis'? After a while, I realised you weren't asking a question,

MysqlTool problems

2001-02-19 Thread Kevin O
Hello all, I'm trying to use MysqlTool 0.90 and am getting the following error when I pull up the web interface: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111) Only thing is, /var/lib/mysql/mysql.sock does exist and I'm able to connec to the database

Re: Setting up data model

2001-02-05 Thread Kevin O
If you mean you link table techadress to table domains, and then billing admin adress to techadress, then i think you'r odd.. You should learn some about 'normalization', look for it on the web or in a book. No, I did not mean to link the tables like that. I simply wanted the Domain table