[PHP-DB] Restarting Mysql

2002-10-31 Thread Michael Conway
I'm debugging a script that locks tables as part of an INSERT script
(using Linux 7.1).  Mysql frequently locks out the tables involved when
there is an error (never gets to UNLOCK command.  I have been rebooting
until now.  Using % mysqladmin shutdown works.  safe_mysqld doesn't.
Any suggestions on getting around the reboot?

 

Thanks.

 

Michael Conway

[EMAIL PROTECTED]

(703) 968-8875

 




Re: [PHP-DB] Restarting Mysql

2002-10-31 Thread Jason Wong
On Friday 01 November 2002 09:04, Michael Conway wrote:
 I'm debugging a script that locks tables as part of an INSERT script
 (using Linux 7.1).  Mysql frequently locks out the tables involved when
 there is an error (never gets to UNLOCK command.  I have been rebooting
 until now.  Using % mysqladmin shutdown works.  safe_mysqld doesn't.
 Any suggestions on getting around the reboot?

Write a script that UNLOCKs the table(s) and run it when the error occurs.

-- 
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *


/*
Fatal error right in front of screen
*/


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php