I have a problem with safe_mysqld quitting every few hours (2 - 8). I can easily restart it with by doing a ./bin/safe_mysqld from the /usr/local/mysql directory, but obviously this only works if I'm there. I'm trying to track down why MySQL keeps crashing , but in the meantime, I'd like to:
Send users to a page instead of the MySQL errors showing up everywhere. I assume I need to substitute something for "or die" on the connect to lines?
On that page have a "Panic Button" for them to click on to restart the mysqld themselves. They could then continue shopping.
I'm familiar with PHP, but have not been able to get the exec() type shell functions to work, so the actual button will probably have to lead to a shell or perl script - which I have no clue how to write.
Send users to a page instead of the MySQL errors showing up everywhere. I assume I need to substitute something for "or die" on the connect to lines?
On that page have a "Panic Button" for them to click on to restart the mysqld themselves. They could then continue shopping.
I'm familiar with PHP, but have not been able to get the exec() type shell functions to work, so the actual button will probably have to lead to a shell or perl script - which I have no clue how to write.