Collections:
Archive JMeter Test Result Data
How to archive JMeter Test Result Data? I have converted all JMeter test result records to TestMan now.
✍: FYIcenter.com
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;
⇒ Truncate Test Case and Test Run Tables
⇐ Update TestMan Test Run Tables
2017-12-13, 1673🔥, 0💬
Popular Posts:
How to generate user birthday dates? Test user birthday dates are frequently needed in testing appli...
How to generate user full names? Test user names are frequently needed in testing applications that ...
How to validate Mod 10 (Luhn Algorithm) checksum? In order to help your programming or testing tasks...
Where to find online test tools? FYIcenter.com has prepared a number of online test tools: Data Look...
How to perform regular expression pattern match with multiple occurrences? To perform a regular expr...