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
