A fix for a MySQL5 Control Panel system boot crash
Nov 09, '05 05:17:00AM • Contributed by: zigzogmac
Nov 09, '05 05:17:00AM • Contributed by: zigzogmac
After sort of crash of the mysqld server, I tried unsucessfully to stop/start the deamon from the fancy MySQL5 System Preferences panel. (I use bash all day at work on linux, so using my Mac is a happy time at home.)
Unfortunately, the Prefs panel didn't work, so I had to use sudo kill to stop the mysqld server processes. The next day, I restarted my PowerBook, but it refused to start in anything other than single user mode. I quickly found that the /etc/hostconfig file has disappeared!
Here's the line used by the MySQL5 control panel in hostconfig at boot time:
Unfortunately, the Prefs panel didn't work, so I had to use sudo kill to stop the mysqld server processes. The next day, I restarted my PowerBook, but it refused to start in anything other than single user mode. I quickly found that the /etc/hostconfig file has disappeared!
Here's the line used by the MySQL5 control panel in hostconfig at boot time:
MYSQLCOM=-NO-
Hopefully, a backup was automatically done by the system. If it was, then after the following standard procedure...
root$ fsck -yf
root$ mount -uw /
...you then just need to copy the backup file and reboot:
root$ cp /etc/hostconfig~ /etc/hostconfig
root$ reboot
Voila! I hope this helps anyone affected by the same issue...
•
[4,883 views]
