Collections:
Load Test Result to MySQL Manually
How to load my JMeter test result manually to MySQL server? I want to verify if the test result fields match with the table columns or not.
✍: FYIcenter.com
You can follow this tutorial to
load your JMeter test result manually to MySQL server.
1. Start JMeter on your computer, open "\fyicenter\First-Load-Test-3.jmx", and run the test plan.
2. Connect to the MySQL server and database with the server information and your username/password.
\fyicenter\mysql\bin\mysql -h localhost -D fyicenter -u john -p NoOneKnows
3. Run the following MySQL command:
load data local infile '\\fyicenter\\Test-Result.csv' into table jmeter_test_result fields terminated by ',' enclosed by '"' lines terminated by '\n' ignore 1 lines; Query OK, 100 rows affected, 0 warnings (0.23 sec) Records: 100 Deleted: 0 Skipped: 0 Warnings: 0
4. Run a SELECT statement to get the first row back:
mysql> select * from jmeter_test_result limit 1, 1; +---------------+---------+----------+--------------+-----------------+- | timeStamp | elapsed | label | responseCode | responseMessage | +---------------+---------+----------+--------------+-----------------+- | 1508425034340 | 2835 | Facebook | 200 | OK | +---------------+---------+----------+--------------+-----------------+- 1 row in set (0.00 sec)
So test result loaded correctly.
Â
⇒ Add JDBC Connection Configuration
⇠Create MySQL Table for Test Result
⇑ Saving Test Results to MySQL Database
⇑⇑ Apache JMeter Tutorials
2017-11-18, 1851👍, 0💬
Popular Posts:
Where to find online test tools? FYIcenter.com has prepared a number of online test tools: Data Look...
How to valid IP addresses? In order to help your programming or testing tasks, FYIcenter.com has des...
How to generate string test values? To help you to obtain large number of string test values, FYIcen...
How to generate date and time test values? Timestamp values are frequently needed in testing almost ...
What are JMeter command line options? You can get see JMeter command line options by running this co...