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 ques

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 con

'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

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 jus

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 t

Setting up data model

2001-02-05 Thread Kevin O
Hello all, I've got a few questions about setting up a data model for a database I'm creating. I want to set it up to be most efficient and would like input from anyone that has the time. I'm setting up your basic customer database, except I'd like to allow for a customer within a customer o