Archive JMeter Test Result Data

Q

How to archive JMeter Test Result Data? I have converted all JMeter test result records to TestMan now.

✍: FYIcenter.com

A

After you have converted data from the jmeter_test_result table to TestMan database, you need move converted data to an archive table as shown in this tutorial.

1. If this the first time, create an archive table, jmeter_test_result_backup, with a "select *" clause:

create table jmeter_test_result_backup as 
   select * from jmeter_test_result;

2. If the archive table, jmeter_test_result_backup, already exists, insert data with a "select *" clause:

insert into jmeter_test_result_backup 
   select * from jmeter_test_result;

3. Then truncate the jmeter_test_result table for the next load:

truncate table jmeter_test_result;

You can also #2 and #3 into a SQL script file and run it:

-- ArchiveJMeterData.sql

use TestMan; 

insert into jmeter_test_result_backup 
   select * from jmeter_test_result;

truncate table jmeter_test_result;

 

Implementing TestMan in MySQL

⇒⇒Test Management Tutorials

2017-12-13, 282👍, 0💬