Re: How can I minimise data transfer when rsyncing subsequent dumps?

[Peter Brawley]

> virtually all the files checksum differently after minor table updates.

Yes, the checksum knows nothing about the sql logic in the files.

> I optimistically thought that any tables with autoincrementing
> primary keys should dump in a deterministic way.

Agreed that's optimistic---doesn't it assume there've been no changes since the inserts?

To get your row-by-row differences, wouldn't you need two-way exclusion joins on paired tables, and wouldn't that be more expensive (by far) than just dumb dumping the data?