MySQL in Startup Files?

[Anon]

I would appreciate anyones experience with web hosting companies that don't support or install MySQL. This is a shared hosting server. I have installed MySQL using SSH access and everything is operating properly. However this weekend the server was rebooted and MySQL was no longer running. I restarted by running 'mysql.server start' and everything started working properly. Is their something I can do to have MySQL load each time the server is rebooted? Do we have to have root access? Any advice would be helpful.

Thanks.

[[deleted]]

"Is their something I can do to have MySQL load each time the server is rebooted?"

yes, read about 'runlevels' and 'initd'

and yes, that will require root access.

A very very bad/naughty/don't-try-this-at-home way of auto_starting mysql could be to use a crontab entry that checks wether mysql is running, and starts it if it isn't. If that were to run every 5-10 minutes, you'd have pretty much the same effect.

[Anon]

Your last suggestion is very interesting. The hosting company provided a script and some instructions for doing the crontab. However they stated "We do not support MySQL or this script so use at your own risk."

At this point I'm not sure what to do because the database is on a shared server and the hosting company is the only one that has root access.

[[deleted]]

If they don't support mysql they are not very likely to want to install the startup for you. On the other hand, if they don't support mysql but you need mysql, why are you staying with them?

[Anon]

My boss wants to keep them because they are local and have been reliable in the past. I just can't believe a hosting company (not a cheap one) does not support MySQL.

Thanks for the info Vincent.