myisamchk warnings -- open tables

2003-01-13 Thread havoc
Since the http://lists.mysql.com/ archives site is down, I'll have to ask this question without the benifit of the archives... I have a (very large) Perl script that has a bad tendency to cause the following warning from myisamchk: myisamchk: MyISAM file /var/lib/mysql//table_name.MYI myisa

Re: Running Without TCP Port

2002-02-22 Thread havoc
DoH! I'm bein a moron here :) Guy, thanx :) On Fri, 22 Feb 2002, havoc wrote: > Date: Fri, 22 Feb 2002 12:32:10 -0600 (CST) > From: havoc <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Subject: Re: Running Without TCP Port > > Just for my clarification, "--sk

Re: Running Without TCP Port

2002-02-22 Thread havoc
Just for my clarification, "--skip-networking" will disable TCP/IP, but still allow mysqld to use a unix socket as specified by "--socket=PATH", correct? On 22 Feb 2002, Guy Davis wrote: > Date: 22 Feb 2002 11:28:35 -0700 > From: Guy Davis <[EMAIL PROTECTED]&g

Running Without TCP Port

2002-02-22 Thread havoc
Is it possible to run mysqld without binding to a TCP port? As in run using only unix sockets? - Jonathan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: Perl DBI to MySQL -- Passing info to query

2001-07-10 Thread havoc
That would not be true. You'd receive a message stating that you had one placeholder, but you were passing 3 arugments, and it script would die on the error. havoc ryc wrote: > > I was not aware of placeholders, and the benifits of using them instead of > using $dbh->quote(

Perl DBI to MySQL -- Passing info to query

2001-07-09 Thread havoc
I'm having some trouble passing some information from my Perl script to the DBI query interface. A short version of my query would look like: my $sth = $dbh -> prepare (q{ SELECT message.name, contents, user.name, message.id FROM message, user WHERE folder='N' and paren