Re: Restarting Mysql
| From: | Jason Wong | Date: | Fri, 01 Nov 2002 07:45:38 +0000 |
| Subject: | Re: Restarting Mysql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-22875@lists.php.net to get a copy of this message | ||
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
*/