MySQL Datagenerator




  1. There is no installation required.
    Extract the zipfile and put the extracted folder "datagenerator" in your local webfolder.
    For most Windows users that is the `htdocs` folder (e.g. D:/xampp/htdocs) because that is the default when you install XAMPP.
    For Linux users the webfolder is probably `/var/www` or `/home/www`, you can find the correct folder in `/etc/httpd/conf/httpd.conf` or `/etc/apache2/sites-available/default` when you installed LAMPP.
  2. That's all you have to do when you have a default webserver installation like XAMPP already installed.
    The only thing you have to check are the mysql serversettings. Normally the SERVER_USER is `root` and the SERVER_PASS is '' (two quotes). When you changed these when you installed XAMPP you have to change them in `/config/config.php`. You can find the SERVER_USER, SERVER_HOST (mostly `root@localhost`) and SERVER_PASS in phpmyadmin.
    The rest of the constants in config.php have correct default values and you can change them optionally, like your preferred applicationlanguage (LANGUAGE) and your preferred landspecific language (QUERYLANGUAGE).
  3. Make sure the folders `templates_c` and `/misc/saved` are writable.
  4. When you are using Linux you have to set the permissions of the folders and the files correct. Set owner to 'nobody' and the group to 'nogroup'. At least the `classes` and `misc` folder.
  5. That's all, now typ "localhost/datagenerator" in your browser and start generating data.

So, only 3 steps for most users:
Extract the zipfile and put the extracted folder "datagenerator" in your local webfolder.
Make sure the folders `templates_c` and `/misc/saved` are writable.
Typ "localhost/datagenerator" in your browser and start generating data.


Choose a database and tables

Choose a database

First you have to choose a local database from the dropdownlist (Or choose a saved configfile you saved earlier).

The following databases are not included in the dropdownlist to prevent accidentally changing: 'information_schema', 'mysql','webauth' and 'phpmyadmin'.

Or a saved configfile

You can open a configfile which you saved earlier.

In the maingrid you can save a configuration by clicking on the 'save this configuration' button.

Optionally adjust the credentials

When your database has a custom username and password, you can fill them in here. Otherwise leave the username to 'root' and the password empty.

Select the tables

Now you can select the tables in which you want to add one or more rows of data.

And click 'continue'.

Customize the values

The application automatically sets default values. Sometimes however it can be handy to have real-like data in your database.
That can be useful for testing `sorting` functions, for viewing the look and feel of a website, checking if functions which do some math are working as you expect etc.


To set custom options you can choose an option in the combo...


... or define your own values...


... or set a range

These are the options:


... or select a field from a table in the same_as column ...


With the refresh button you can see the effect of your changes in the `example values` column.

Generate data

After you are satisfied with the example values in the `example values` column you can export the data to text or import in the database immediately.


Config options

There are many configuration settings you can change to your personal needs or wishes.