Re: How to start mysql at boot time?
From: Dave Uhring (daveuhring_at_yahoo.com)
Date: 06/16/05
- Next message: Steve P: "NEWBIE: Best way to upgrade?"
- Previous message: Bas Keur: "Re: How to start mysql at boot time?"
- In reply to: Bas Keur: "Re: How to start mysql at boot time?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Thu, 16 Jun 2005 15:27:05 -0500
On Thu, 16 Jun 2005 21:17:14 +0200, Bas Keur wrote:
> 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)
A UPS is a better solution :-)
> 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.
Pending operations within the database may not have completed in the case
of a reboot without having shut down the daemon. When you executed your
reboots the daemon had probably been idle.
Checking the mysql.server script it appears that a kill $mysqld_pid is
executed then wait for the daemon to remove the PID.
> Either way, i'll use the rc.shutdown also from now on :)
Much safer, IMHO.
- Next message: Steve P: "NEWBIE: Best way to upgrade?"
- Previous message: Bas Keur: "Re: How to start mysql at boot time?"
- In reply to: Bas Keur: "Re: How to start mysql at boot time?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
