Re-setting mysql as a service

[wink martindale]

Hello,

I installed mysql server 4.1 last month. When I installed it, I set it
to run as a service to start automatically. However, for some reason,
that no longer occurs. I can't even see the mysql service running from
services viewer in win xp. I now have to manually start mysql server
each time I reboot.
Can someone please tell me how I can Re-set mysql to run as a
service?? Or, if I re-install mysql, will it retain the db's already
created??

TIA,

Wink

[Bill Karwin]

wink martindale wrote:

Can someone please tell me how I can Re-set mysql to run as a
service??
It's probably most straightforward and safest to reinstall MySQL. You
could hand-edit the registry to recreate the service entry, but that is
neither quicker nor more likely to succeed.
Or, if I re-install mysql, will it retain the db's already
created??

It "should" retain the databases, or any other files that aren't part of
the default install. But it's always a good idea to back up your
databases before doing something like changing the DBMS software.

Remember: computers are out to get you. Not users in general, but YOU.
It's personal. ;-)

Regards,
Bill K.

[Jeff North]

On Wed, 28 Sep 2005 08:45:14 -0500, in mailing.database.mysql wink
martindale <wi**@martindale.com> wrote:

| Hello,
|
| I installed mysql server 4.1 last month. When I installed it, I set it
| to run as a service to start automatically. However, for some reason,
| that no longer occurs. I can't even see the mysql service running from
| services viewer in win xp. I now have to manually start mysql server
| each time I reboot.
| Can someone please tell me how I can Re-set mysql to run as a
| service?? Or, if I re-install mysql, will it retain the db's already
| created??

Reboot your machine so you can see the default properties.

Right mouse click the My Computer icon. Select Manage from the popup
menu.
The mmc window will open. Select Service and Applications.
Click Services. The right panel will list all the services that are
available to your machine.
Scroll to the MySQL entry.
My entry reads as:
mySQL Started, Automatic, Local system
Double click mySQL to bring up the properties box.
Set the StartType to Automatic, click the Start button.

Have a look at the MySqlAdmin icon in the systray. Is it green?
If it is then your up and running, if not then there could be an error
in you my.ini file.
---------------------------------------------------------------
jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------

[Larry]

"wink martindale" <wi**@martindale.com> wrote in message
news:rd********************************@4ax.com...

Hello,

I installed mysql server 4.1 last month. When I installed it, I set it
to run as a service to start automatically. However, for some reason,
that no longer occurs. I can't even see the mysql service running from
services viewer in win xp. I now have to manually start mysql server
each time I reboot.
Can someone please tell me how I can Re-set mysql to run as a
service?? Or, if I re-install mysql, will it retain the db's already
created??

TIA,

Wink

[Larry]

try Start>Control Pannel>Administrative Tools>Component Services

This should bring up a list of services which you can reset to run at
startup etc.

Let me know if this works.
Larry
"wink martindale" <wi**@martindale.com> wrote in message
news:rd********************************@4ax.com...

Hello,

I installed mysql server 4.1 last month. When I installed it, I set it
to run as a service to start automatically. However, for some reason,
that no longer occurs. I can't even see the mysql service running from
services viewer in win xp. I now have to manually start mysql server
each time I reboot.
Can someone please tell me how I can Re-set mysql to run as a
service?? Or, if I re-install mysql, will it retain the db's already
created??

TIA,

Wink