|Classes of Martin Latter||PHP Database Fill||README.md||Download|
This repo is shoved into retirement. The schema file parsing and single-threaded nature of PHP, along with high memory usage makes this package obsolete.
More efficient alternatives are MySQL-Filler and mysql_random_data_load.
Populate MySQL database tables with test data by parsing the SQL schema file.
: https://tinram.github.io/images/databasefiller-data.png ![Database-Filler database]
Originally, I needed to populate a database containing 14 complex tables. Tools such as Spawner are ideal for populating small tables, but in this case, specifying the datatypes for 300+ fields to initiate Spawner would have been insanity.
Instead, why not parse the SQL schema?
: https://tinram.github.io/images/databasefiller-execute.png ![Database-Filler execute]
Configuration boolean toggles (
Ensure the database already exists in MySQL e.g. for the test schema:
Adjust the array connection details and parameters in the file databasefiller_example.php
Then execute this file with PHP on the command-line:
or run the file through a web server e.g.
SQLParser would have been used in this project had it been available in 2014.
Database Filler is released under the GPL v.3.