Re: How to start mysql at boot time?
From: Bas Keur (bas.keur_at_dmrt.net)
Date: 06/16/05
- Previous message: Dave Uhring: "Re: How to start mysql at boot time?"
- In reply to: Dave Uhring: "Re: How to start mysql at boot time?"
- Next in thread: Dave Uhring: "Re: How to start mysql at boot time?"
- Reply: Dave Uhring: "Re: How to start mysql at boot time?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 16 Jun 2005 21:17:14 +0200
>> Voila !
>> If this is the official way ?
>> It's my way, oh yes thats official around here :))
>
> You also need a line in /etc/rc.shutdown to stop the mysql server cleanly.
> Unless you want to risk corruption of your databases.
Now thats a very good point indeed.
However, if for some reason (ex. power surge) the system is kicked
down, i always have to do a `mysqlcheck -uxxx -pxxx -A` and pray
i don't have to do a drop/create / mysql db < /backup/db.sql
(note: cron backup 2 times a days keeps bad karma away)
BUT..... when i do a `reboot` ... i never ever had any corruption...
Which leaves me 2 options. Correct me if i'm wrong.
1: If a deamon makes a pid file, it wil be stopped anyway..... ?
2: The `reboot` sync's the fs, so i was lucky no corruption ever happend due
reboot.
Either way, i'll use the rc.shutdown also from now on :)
-Bas
- Previous message: Dave Uhring: "Re: How to start mysql at boot time?"
- In reply to: Dave Uhring: "Re: How to start mysql at boot time?"
- Next in thread: Dave Uhring: "Re: How to start mysql at boot time?"
- Reply: Dave Uhring: "Re: How to start mysql at boot time?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]