On Jul 23, 6:54*am, Frank Elsner <Frank.Els...@spamfence.net> wrote:
> Unruh wrote:
> > Mtek <m...@mtekusa.com> writes:
>
> >>Hi,
>
> >>I have 2 servers. *One is a web/mail server and the other is a backup
> >>server. *Currently, to back up the server I have a script that runs
> >>which basically tar's the entire apache tree along with dumps of the
> >>MySQL databases and use SCP to send them to the backup server.
>
> >>Later, a script runs on the backup server which untar's the files and
> >>imports the databases.
>
> >>My question is, is this a good backup method? *I see many people using
>
> > OK but cumbersome.
>
> >>RSYNC. *Would this be a better solution? *If yes, how would I do it??
>
> > Yes, it would be. rsync also checks the data for correctness ( hashes the
> > same) while transfering it.
>
> > It also transfers only what has changed, not everything every time.
>
> What about database file with holes, postgres comes to my mind.
> Is it save to rsync them?
>
> --Frank- Hide quoted text -
>
> - Show quoted text -

Well, are you also saying that I do not need to export and re-import
the database tables? That it will copy the databse files and mySQL
will work fine on the backup server?

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.

Regards,

John.