I wonder if that's where the issue came into it.
take a look at individual records, if they are in the first db, and not
in it after a restore that's where I'd be looking, are you getting any
warnings on the load?.
I also wonder if it might be something like max packet size conflicts
between the dumping and loading systems perhaps?
I'm getting closer to pulling the trigger on this myself so I'm curious
as to the result.
On 29/05/12 23:09, Daniel Schütze wrote:
>How did you do the migration of the database?
I took a mysql dump from the replication slave, copied it over to the
test box and imported it into a completely empty mysql installation
with mysql < dumpfile.sql
Daniel Schütze
------------------------
CWA International
Balmoral House
9 John Street
London
WC1N 2ES
(t) + 44 (0)20 7242 8444
(e) d...@cwa.uk.com
(w) http://www.cwa.uk.com/
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
