file check

Peter Corlett abuse at cabal.org.uk
Tue Jul 15 13:18:59 BST 2008


On Tue, Jul 15, 2008 at 01:05:12PM +0100, Christopher Jones wrote:
> <gratitude>Thanks for the help!</gratitude>
> I've just optimised the MySQL database that some of you helped me to speed
> up a few weeks ago. I had a (data only) dump of the database before
> optimisation, and one after. I need to make sure that the optimisation
> hasn't messed up the data in any way, and figured that the two dumps
> should be identical assuming everything is hunky dory.

> Of course there could be a flaw in my plan.....

Relational databases don't guarantee ordering, so while your dumps may
indeed contain the same data, it may not necessarily be in the same order
and so a comparison could fail.

> (Standing by with full-body flame-proof armour)

Please don't top-post.



More information about the london.pm mailing list