List:General Discussion« Previous MessageNext Message »
From:Nunzio Daveri Date:September 9 2010 2:12pm
Subject:Re: Replaying the mysqld.log file from production onto QA???
View as plain text  
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 :-)

Nunzio




________________________________
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?

TIA...

Nunzio


      
Thread
Replaying the mysqld.log file from production onto QA???Nunzio Daveri8 Sep
  • Re: Replaying the mysqld.log file from production onto QA???Baron Schwartz10 Sep
Re: Replaying the mysqld.log file from production onto QA???andrew.2.moore8 Sep
  • Re: Replaying the mysqld.log file from production onto QA???Nunzio Daveri9 Sep
    • Re: Replaying the mysqld.log file from production onto QA???Johan De Meersman10 Sep
      • Re: Replaying the mysqld.log file from production onto QA???MySQL)10 Sep
        • Re: Replaying the mysqld.log file from production onto QA???Johan De Meersman10 Sep
          • Re: Replaying the mysqld.log file from production onto QA???Johnny Withers10 Sep
        • RE: Replaying the mysqld.log file from production onto QA???Jerry Schwartz10 Sep