Comments on: Generating test data for MySQL tables

By: maurisrx

maurisrx — Fri, 23 Dec 2016 07:06:47 +0000

Thank you for the tutorial. I was searching on how to generate a big data and your tutorial helps a lot.

By the way, I install it on a XAMPP server on a Win 10 machine, and it works well so far.

By: Plato Collins

Plato Collins — Sat, 21 Nov 2015 23:01:42 +0000

I use often this tool in http://www.yandataellan.com. You can generate up to 10.000 rows of data in several file formats (CSV, Excel, SQL, JSON, HTML, and XML) and for free!. Take a look…

By: James

James — Fri, 06 Feb 2015 19:07:17 +0000

Oops, this is the correct URL: http://codecanyon.net/item/mysql-datagenerator-importexport/5315175

By: James

James — Fri, 06 Feb 2015 19:03:23 +0000

I’m using MySQL Datagenerator. http://codecanyon.net/item/fast-easy-calendar-with-app/8498020?ref=wolberspl
It has many options and possibilities, also country related data can be generated. It scans your databases, so you don’t have to fill in column titles and datatypes, it’s all recognized.

By: Fabian

Fabian — Fri, 23 Jan 2015 03:27:56 +0000

Thx for that blog! Someone published a docker image for that app https://github.com/LaiNathaniel/docker-generatedata so you can just use it in conjunction with the mysql docker image in case you just want to play:

sudo docker run –name mysql -e MYSQL_ROOT_PASSWORD=marzipan -d mysql && sudo docker run –link mysql:mysql -i mysql sh -c ‘exec mysql -h”$MYSQL_PORT_3306_TCP_ADDR” -P”$MYSQL_PORT_3306_TCP_PORT” -uroot -p”$MYSQL_ENV_MYSQL_ROOT_PASSWORD” -e “create database fingerfood”‘ && sudo docker run –name mysql-generatedata –link mysql:mysql -p 80:80 -d lai475nathaniel/docker-generatedata

generatedata will be listening on http://localhost/ and the database details will be:

hostname: mysql
database: fingerfood
username: root
password: marzipan

By: Leonardo

Leonardo — Fri, 28 Feb 2014 20:42:42 +0000

Hi!
I’ve been using this site, and I have a problem when I choose “Custom List” as a Data Type and then I choose de option “At least 4″ and then I put four words separated by this symbol ” | ” wich I add also at the end of this list so it is posible to have an empty row. The problem is that this system writes this “, ” instead of don’t write nothing when correspond to an empty element, so in some rows I got “word 1, , word 4″ or even ” , , , ”
Is there any solution for this?

Thanks a lot. Greetings.

By: pcrews

pcrews — Tue, 11 Feb 2014 19:23:21 +0000

That is a very cool tool. Thank you for sharing that. This is perhaps more primitive, but might also be useful (it is a part of the random query generator tool):
https://github.com/RQG/RQG-Documentation/wiki/RandomDataGenerator