MySQL Forums
Forum List  »  Newbie

Re: Dump and reload gives different numbers of records
Posted by: Henry Law
Date: June 27, 2021 07:09AM

There was nothing (literally) in the server logs and both CHECK TABLE and ANALYZE TABLE ran clean.

As you suggested I loaded up the dumped table into a differently-named database on the production server and ran some versions of the "Compare data in two tables" query in the link you posted (there's lots of really useful stuff in there!). Those queries showed numerous mismatches, but not all in the same direction, so to speak: there were records missing from both "source" and the reloaded "target" table.

The live database is updated overnight, so this morning I dumped it off and again loaded it into the differently-named database. I don't know how to put this, or indeed how to explain it, but the record counts and the sum of the file sizes in each record are now the same. Phwattt? Believe me, I did the dump/reload/query process several times on the original and got the same (mismatched) result; but now it's fixed itself. Worrying.

Thank you for the help: my problem is solved (umm ... for now) and I've learned a great deal in the mean time.

Options: ReplyQuote

Written By
Re: Dump and reload gives different numbers of records
June 27, 2021 07:09AM

Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.