I want a tool for populating a MySQL database with random data.
- The data generated for the primary and secondary keys should be coherent, so the data will not cause integrity errors.
- It should provide a way to create rules about how to generate data for the fields. For example, choose from a list of words, or just create a random alphanumeric text.
- It should be really simple to install and use. It must not be part of a bigger application with a lot of features which have nothing to do with data generation.
It must work from the command line. In this use case, a nice UI for configure the application is not useful.
Bonus: it will be great if it's open source.