Il 23/07/2008 15.06, Mtek ha scritto:

> My goal obviously is if the main server goes down, I can shut it down,
> change my router to point to the other server, and I'm up and running
> again.

For mysql I think it is better to recreate database from mysqldump files.
Doing this, you will loose changes made after mysqldump command.
If this is not acceptable, you can set up mysql in master/slave mode and
your slave has always the same data that master has. See mysql
documentation on how to set up this, it is quite simple.