Re: how to recover after power outage

2009-04-06 Thread John Almberg
Check the machine-hostname.err file when you manually try and start MySQL. Provided that you have mysql_enable=YES in /etc/rc.conf you should be able to manually attempt to start with /usr/local/etc/rc.d/mysql-server start (it seems to work reliably when you type out the entire command path-

Re: how to recover after power outage

2009-04-06 Thread Roland Smith
On Mon, Apr 06, 2009 at 02:08:18PM -0400, John Almberg wrote: snip Okay, so my new database server is running with backup data and I am trying to salvage the old database, or what's left of it. Unfortunately, it seems like what's left of it, is not much. the /var/db/mysql directory tree

how to recover after power outage

2009-04-05 Thread John Almberg
Blast... my beautiful FreeBSD servers were rudely switched off when my data had a power outage a couple hours ago. They restored power about 30 minutes later, and one box came up no problem. The other has a login prompt on the serial console, but my login does not work. I get a Login

Re: how to recover after power outage

2009-04-05 Thread Glen Barber
On Sun, Apr 5, 2009 at 2:59 AM, John Almberg jalmb...@identry.com wrote: Blast... my beautiful FreeBSD servers were rudely switched off when my data had a power outage a couple hours ago. They restored power about 30 minutes later, and one box came up no problem. The other has a login prompt

Re: how to recover after power outage

2009-04-05 Thread John Almberg
On Apr 5, 2009, at 4:41 AM, Glen Barber wrote: On Sun, Apr 5, 2009 at 2:59 AM, John Almberg jalmb...@identry.com wrote: Blast... my beautiful FreeBSD servers were rudely switched off when my data had a power outage a couple hours ago. They restored power about 30 minutes later, and one

Re: how to recover after power outage

2009-04-05 Thread Michael Powell
John Almberg wrote: On Apr 5, 2009, at 4:41 AM, Glen Barber wrote: On Sun, Apr 5, 2009 at 2:59 AM, John Almberg jalmb...@identry.com wrote: Blast... my beautiful FreeBSD servers were rudely switched off when my data had a power outage a couple hours ago. They restored power about 30

Re: how to recover after power outage

2009-04-05 Thread John Almberg
The main app is MySQL. I don't think it is running, but can't really tell unless I can log in. I have backups, and while NYI is trying to get this box running, I'm setting up a new database server, just in case... If you were lucky having the guys at NYI login to single user mode at the

Re: how to recover after power outage

2009-04-05 Thread Michael Powell
John Almberg wrote: [snip] Okay, so the machine is back online and I can log in again. The hardware is only 18 months old or so... good quality stuff, so hopefully nothing is physically damaged. We'll see... Unfortunately, mysql isn't working at the moment... will make a backup of data

Re: how to recover after power outage

2009-04-05 Thread John Almberg
On Apr 5, 2009, at 2:10 PM, Michael Powell wrote: John Almberg wrote: [snip] Okay, so the machine is back online and I can log in again. The hardware is only 18 months old or so... good quality stuff, so hopefully nothing is physically damaged. We'll see... Unfortunately, mysql isn't