Jeremy Zawodny wrote:>
> On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote:
> >
> > The other solution is rsync. I dont know much about this guy yet,
> > but I have some concerns with using it to copy over large remote
> > files. For example, if I have a 1.2 gig table that has been heavily
> > modified over a weeks work, how reliable is the remote file after
> > rsync? I guess Im just concerned about data integrity.
>
> I've never had rsync corrupt data, and we routinely push around
> gigabytes per day (as a company) using rsync.
>
Is this rsync over ssh ?
I've had a few problems with rsync over ssh with mysql files. Althought
the size of the files appeared to be the problem, not the fact they were
mysql files.
In the end it made no difference, and the tables were often created on
the fly for an update, and myisampk'ed - so rsync could not see and
similarities and ended up copying the lot.
Greg
> Jeremy
> --
> Jeremy D. Zawodny, <[EMAIL PROTECTED]>
> Technical Yahoo - Yahoo Finance
> Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
>
> MySQL 3.23.41-max: up 8 days, processed 106,728,794 queries (140/sec. avg)
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
><[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
