So.. I am trying to mimic replaying production like queries so joins, temp
tables etc... are stuff I am trying to test as well. Just doing a dump and
import is no more than export and importing, I also want to test selects,
updates :-) Thanks for replying :-)
From: "andrew.2.moore@stripped" <andrew.2.moore@stripped>
To: nunziodaveri@stripped; mysql@stripped
Sent: Wed, September 8, 2010 4:19:19 PM
Subject: Re: Replaying the mysqld.log file from production onto QA???
Try using a mysqldump.
----- Reply message -----
From: "ext Nunzio Daveri" <nunziodaveri@stripped>
Date: Wed, Sep 8, 2010 19:25
Subject: Replaying the mysqld.log file from production onto QA???
To: "mysql@stripped" <mysql@stripped>
Hello all, I am trying to "REPLAY" the mysqld.log file from a production 5.1.4
server onto a QA server with 5.5 running and was wondering if there is an easy
way of replaying the mysqld.log file? Just want to make sure all of the kinds
of inserts, updates, selects and deletes work just as well on the 5.5 box, esp
since we are turning on replication and copying tables from another server onto
this server. Any ideas please?