Hi Scott,
mysqladmin can issue a kill from the command line. You will have to
issue a mysqladmin -u etc. etc. processlist to get the process id from
mysql and then you can issue a mysqladmin -u etc. etc. kill <mysql
process id>
Regards
---------------------------------------------------------------
********** _/ ********** David Logan
******* _/ ******* ITO Delivery Specialist - Database
***** _/ ***** Hewlett-Packard Australia Ltd
**** _/_/_/ _/_/_/ **** E-Mail: [EMAIL PROTECTED]
**** _/ _/ _/ _/ **** Desk: +618 8408 4273
**** _/ _/ _/_/_/ **** Mobile: 0417 268 665
***** _/ ******
****** _/ ******** Postal: 148 Frome Street,
******** _/ ********** Adelaide SA 5001
Australia
i n v e n t
---------------------------------------------------------------
-----Original Message-----
From: Scott Haneda [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 20 June 2006 8:32 AM
To: [email protected]
Subject: Aborting a greedy querry from the command line
Sometimes I will issue something, slip of the fingers, and mysql will
chew
on it for hours, the best I can do is control-z to get out of it and log
back in. But, I just learned these processes are still running, and I
have
to go in and kill them by hand.
Is there any easy way to abort from the command line and have it really
stop
that query?
--
-------------------------------------------------------------
Scott Haneda Tel: 415.898.2602
<http://www.newgeo.com> Novato, CA U.S.A.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
