Richard Welty rwelty at
Sat Feb 7 18:13:48 UTC 2004

On Sat, 07 Feb 2004 13:07:10 -0500 Mitch Wiedemann <mc2 at> wrote:

> I put the data in /home/mysql so that I can use rsync to move all 
> /home/* to a backup server each night.

> I suppose, now that you mention it, running a mysqldump  to /home/mysql 
> and THEN running my rsync would be better since I realize the data table 
> copy isn't the best idea in the world, although it hasn't caused me any 
> trouble so far...

you've been incredibly lucky and the database isn't very busy.

copying a live database that's doing much of anything at all is largely
guaranteed to fail sooner or later.

dump, copy the backup, and restore on the second system. that, or
install some sort of replication solution.

Richard Welty                                         rwelty at
Averill Park Networking                                         518-573-7592
    Java, PHP, PostgreSQL, Unix, Linux, IP Network Engineering, Security

More information about the users mailing list