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