For Programmers: Free Programming Magazines  


Home > Archive > PHP Programming > December 2004 > MySQL won't run









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author MySQL won't run
Leviathan

2004-12-23, 8:56 pm

This is my problem:
After I start apache and MySQL, mysqld.exe runs for a few seconds and then
shuts down automatically. It worked perfectly a few hours ago and now it
suddenly doesn't. I've tried reinstalling, upgrading, nothing works. What is
going on here?

Note: only reply if you have a useful answer. I've had my share of problems
with apache/php/mysql and I'm tired of getting replies like 'try google'.
Yes, I've tried Google and I have not found a solution to my problem.


Gordon Burditt

2004-12-23, 8:56 pm

>This is my problem:
>After I start apache and MySQL, mysqld.exe runs for a few seconds and then
>shuts down automatically. It worked perfectly a few hours ago and now it
>suddenly doesn't. I've tried reinstalling, upgrading, nothing works. What is
>going on here?


Read the error log ($hostname.err in the parent directory of the
databases). It might tell you something useful, like the server
aborted (and why), that tables are corrupt, that there's a syntax
error in a config file, etc.

What happened between "a few hours ago" and now? Perhaps some of
the MyISAM tables need cleaning with myisamchk if the server was
not shut down cleanly.

>Note: only reply if you have a useful answer. I've had my share of problems
>with apache/php/mysql and I'm tired of getting replies like 'try google'.
>Yes, I've tried Google and I have not found a solution to my problem.


Gordon L. Burditt
Janwillem Borleffs

2004-12-23, 8:56 pm

Leviathan wrote:
> This is my problem:
> After I start apache and MySQL, mysqld.exe runs for a few seconds and
> then shuts down automatically. It worked perfectly a few hours ago
> and now it suddenly doesn't. I've tried reinstalling, upgrading,
> nothing works. What is going on here?
>


There a couple of things which you can check:

* Resources: Open the Processes tab of the task manager interface and see
what happens when you start MySQL
* Check your system for virusses/spyware
* Do you run mysql as a service? If not, try that. See:
http://dev.mysql.com/doc/mysql/en/W...rt_service.html
* When mysql is already installed as a service, check the logs
* The obvious (always solves many strange behaviours in Windows): Restart
your system


JW



Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2010 codecomments.com