fixed issue with not closing the mysql connection
updated example output files