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
>
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
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
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.
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
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
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
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
$ 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