Re: Auto_Increment

2001-04-15 Thread Roel Vanhout
On Sun, Apr 15, 2001 at 08:20:10PM +0100, Jamie S Buchanan wrote: > And what exactly are myISAM and ISAM tables? http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html#Table_types > (a quick web search gave me: -the Information centre for South African Music >

Re: relationship/field design

2001-04-12 Thread Roel Vanhout
On Thu, Apr 12, 2001 at 03:16:42PM -0700, Dennis Gearon wrote: > The biggest problem seems to be structuring the tables to force the > requirement for at least ONE email address, but not having to create > lots of empty fields. Looks like you're looking for foreign keys, but you can't do that in

Re: connecting to mysql using php

2001-04-12 Thread Roel Vanhout
This is a real RTFM, but here we go: On Thu, Apr 12, 2001 at 04:03:20PM -0700, josh kneedler wrote: > i'm trying to connect to mysql using php so that i can do web based > queries of my tables. i'm new at this so here are some questions: > 1. is localhost just the ip of my server Yes. Or just

Re: Cracking Win 2000 hash?

2001-04-12 Thread Roel Vanhout
Do you have code on how it is encrypted? 'on a windows 2000 box' doesn't say much. Windows passwords are stored in the sam database, in a binary format, unreadable by users (and even by admins). You can brute force those with l0pthcrack (www.l0pht.com), I don't know if it works for windows 2000.

Re: uninstalling MySQL

2001-04-08 Thread Roel Vanhout
rpm -qa | grep mysql if nothing found, rm -rf /usr/local/var rm -rf `find /usr/local/bin/ | grep mysql` rm -rf /etc/my.cnf This should catch about everything. cheers, roel On Sun, Apr 08, 2001 at 12:24:08AM -0400, David Loszewski wrote: > how do I uninstall MySQL 3.22 after installing it? wo

Re: Advice on where to go next in profiling a query

2001-04-07 Thread Roel Vanhout
There is an option long_query_time that you can use to log query that take longer then a preset time, if that's of any help. cheers, roel On Sat, Apr 07, 2001 at 02:05:13PM +0100, Ewan Birney wrote: > > > We are very happy users of MySQL, which we run a nice big genome database > on. We hav

Re: mySQL - maker

2001-04-05 Thread Roel Vanhout
On Thu, Apr 05, 2001 at 06:42:25PM +0200, Leif Sundin wrote: > I have problems with mySQL-maker, I can't connect to my mySQL > database. I have a account at http://www.cihost.com At home we have a > local network, and my friend have a mySQL database on his computer.. > and that database I can conn

turning logging on/off while server is running

2001-04-05 Thread Roel Vanhout
Hi all, Is there a way to turn the query logging on and off while the database server is running? Right now I have a script that stops and restarts the database with loggin on or off depending on the parameters, but this is not so great; I was wondering if there is another way. Also, is there a w

Re: Moving MySQL database(s)

2001-04-05 Thread Roel Vanhout
$ mysqladmin -u -p create and then $ mysqldump -h -u -p | mysql -h -u -p or $ mysqldump -h -u -p > dbdump.sql $ mysql -u -p < dbdump.sql cheers, roel On Thu, Apr 05, 2001 at 05:06:24PM +0100, Graham Nichols wrote: > I've developed my mysql databases/tables on a local intranet ser