MySql failing to start on Server Reboot

S

SuperStar

Verified User
Joined
Jan 6, 2005
Messages
8
Location
New Zealand
When the server is rebooted, the mysqld fails to start, or more importantly the databases are not accessible until I issue a "service mysqld restart" or equivalent.

OS: Redhat 9
Mysql version: 4.0.25

Can someone tell me where to look to see what is failing, or where to look to ensure it is starting correctly?

Thanks in advance.
 
As the system restarts the results of all the service start commands should scroll up the screen.

Of course you can't see that if you're not there watching a monitor.

Depending on the OS distribution you're using your system may or may not also keep a copy of the commands' outputs.

Or you may be able to find why the service didn't restart by finding and checking the proper logfile.

Jeff
 
Thanks jeff. I am working off a VPS from ther remote location. Its also that logfile that I wish tofind out the location of!

Cheers
Nick.
 
Some VPS providers can actually provide you with a web-based or shell-based link where you can log in and see your virtual server boot.

As far as the boot log file; I'm not sure where it is, and it's probably OS distribution specific.

Jeff
 
I thought of something else...

It's possible that your VPS won't allow MySQL to run as a daemon; it's possible it has to run under inetd or xinetd.

Jeff
 
Jeff, an update on this:

When rebooted with virtuozzo there are no problems. When the server is rebooted from within the directadmin control panel (i.e. entering the password), thats when mysql stuffs up, and won't work until the mysqld service is restarted.

I am still not sure where the mysql logs are. They aren't in /var/log/

Any ideas?
 
You must log in or register to reply here.
Back
Top