On Wednesday 27 March 2013 10:24 PM, Ritesh Raj Sarraf wrote:
> sql-sync has 2 options:
> * Either take dumps on both the src and the target, and then rsync the
> delta 
> * Otherwise, take mysqldump of the src and compress it before transfer

Calling system(rsync -e 'ssh ' -akzv --exclude=".git"
--exclude=".gitignore" --exclude=".hg" --exclude=".hgignore"
--exclude=".hgrags" --exclude=".bzr" --exclude=".bzrignore"
--exclude=".bzrtags" --exclude=".svn" --stats --progress
--remove-source-files u...@www.domain.com:/tmp/db.sql
/tmp/rhut_staging.sql.YIWFbj);
receiving incremental file list
db.sql

The reality is that it will not do any diff because
/tmp/rhut_staging.sql.YIWFbj is non-existent of the target machine,
which basically means it will be full-replicated.
And the size of that sql is 372MiB in my case. A complete waste of
resources. Please, if you could fix this. Or convey it to the upstream devs.

-- 
Ritesh Raj Sarraf | http://people.debian.org/~rrs
Debian - The Universal Operating System


Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to