Re: stopping a query

2002-09-27 Thread Ozette Brown
Robert, To stop a running query, you'll need to do a 'myqsladmin processlist' and once you find the PID for the query, issues a "mysqladmin kill PID". This should do the trick. Thanks, Ozette Robert Citek wrote: >Hello all, > >How do I stop a query once i

Re: query

2002-05-27 Thread Mr. Ozette Brown
_insert_id() as ID from TABLE limit 1; Thanks, Ozette > > Record is like this:- > > ID name gender > 1 aF > 2 bM > 3 cM > 4 dF > 5 eM > > Result should be like this:- > > I

Re: myisamchk and table corrupt

2002-03-25 Thread Mr. Ozette Brown
hould work. If this does actually work, then you should consider doing a database dump then rebuilding your database from the dump. Thanks, ozette Patrick Hsieh wrote: >Hello list, > >There's an corruption in my mysql table. >I tried to use myisamchk -o to recovery, but still

Re: mysql and snort

2002-03-25 Thread ozette
Idan, Check out: http://www.incident.org/snortdb/ Thanks, Ozette Idan Dolev wrote: >Hi, > >I am pretty new guy dealing with mysql database, and I am sorry if this has >being asked before. >Are their any doc explaining how to integrate snort and mysql ? > >Best r

Re: FreeBSD+MySQL

2002-03-22 Thread Ozette Brown
Dan Nelson wrote: > In the last episode (Mar 22), Ozette Brown said: > > Andrey, > > > > Thank you for the reply. > > > > I read somewhere that when checking your maximum file descriptors your >"kern.maxfiles > > should be greater than kern.maxfi

Re: FreeBSD+MySQL

2002-03-22 Thread Ozette Brown
ther mailing list entries where people have the exact same problem. > > The only solution I received was to switch to a Linux OS. > > > > I've also read that there is a threading problem with FreeBSD+MySQL on > > an SMP machine. I'm running a ma

FreeBSD+MySQL

2002-03-22 Thread Ozette Brown
ve also read that there is a threading problem with FreeBSD+MySQL on an SMP machine. I'm running a machine with only 1 processor. Do you have any idea as to what may be causing this problem and if so, do you have a suggested so

Unknown database

2002-03-20 Thread Ozette Brown
problem and we are all running some 4.x version of FreeBSD. Does anyone have any ideas? Any help is very much appreciated. Thanks, Ozette - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Conversion from ISAM to MYISAM table format

2002-03-06 Thread Mr. Ozette Brown
update), what will happen? Will the affected tables become corrupt or will MySQL lock the table, perform the Alter, then unlock the table so the table can be inserted or updated? Thanks, Ozette -- ___ Emai

Database connections

2002-02-04 Thread ozette brown
d I'd expect to see an "Aborted..." message in my database.err log file but I don't. Can you shed some light on this? Lastly, I have a CGI-BIN script that produces dynamic webpages and people sometimes click stop, then start (especially when doing searches) multiple times.