So for various reasons not worth getting into here, I decided to get rid of my VPS mysql server, and instead run mysql on my VPS webserver. This entailed installing the mysql server, which was fairly painless. The whole thing has been working great in this configuration, except for one small thing: the mysql server doesn’t automatically restart when the server is rebooted.
So the normal way I manually start mysql is by running
This works fine. Permissions and ownership of /etc/init.d/mysql is the same as every other file in that directory.
I have symbolic links to /etc/init.d/mysql in two places:
I know that these symbolic links aren’t messed up because I’ve started the mysql server by running “/etc/rc3.d/S99mysql start”. I know that I’m in run level three from “who -r”. But clearly /etc/rc3.d/S99mysql is either not getting run or fails when it runs, because mysql is never running after a reboot.
Normally I’d watch for error messages on the console during boot, but for a VPS server there doesn’t seem to be a console. dmesg doesn’t seem to work, and even if it did, it probably wouldn’t include messages printed by init scripts. So I’m a bit perplexed as to how to even debug this. Any advice?