PHP Database Fill: Fill records of MySQL tables with test data

Recommend this page to a friend!
  Info   View files Example   View files View files (5)   DownloadInstall with Composer Download .zip   Reputation   Support forum (1)   Blog    
Last Updated Ratings Unique User Downloads Download Rankings
2020-09-05 (24 days ago) RSS 2.0 feedNot enough user ratingsTotal: 358 All time: 6,803 This week: 279Up
Version License PHP version Categories
database-fill 0.52GNU General Publi...5.3PHP 5, Databases, Testing
Description Author

This class can fill records of MySQL tables with test data.

It takes the SQL dump file of a MySQL database and parses it to extract the list of database tables.

The class executes SQL statements to insert records on the MySQL database tables.

The new record field values can be generated randomly or set to a constant value.

The number of records to insert, the range of characters to use in random data and the character set encoding are configurable parameters.

Picture of Martin Latter
  Performance   Level  
Name: Martin Latter is available for providing paid consulting. Contact Martin Latter .
Classes: 7 packages by
Country: United Kingdom
Age: ???
All time rank: 147565 in United Kingdom
Week rank: 142 Up3 in United Kingdom Up
Innovation award
Innovation award
Nominee: 4x


Database Filler

Fill MySQL database tables with test data by parsing the SQL schema file.


  • Quickly populate database tables with row data for testing SQL data retrieval.
  • Assist in testing complex database schema, before moving the database to a production environment.
  • Check table field population with specified datatypes, potential data truncation, visual cues etc.
  • Test database connection encoding and character encoding, and data insertion speeds.

[1]: ![Database-Filler database][1]


Originally, I needed to populate a database containing 14 complex tables. Tools such as Spawner are useful 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?

[2]: ![Database-Filler execute][2]

Database Requirements

  1. The script expects the database schema to exist in MySQL (`mysql -u root -p < test.sql`).
  2. All table names and column names in the MySQL schema require back-ticks.
  3. Unique keys must be removed from tables when using the option 'random_data' => FALSE


  • The majority of MySQL datatypes are supported.
  • Any foreign keys are disabled on data population.
  • Random character generation is slow in PHP, and such slowness further depends on field length, number of fields, and the number of rows being generated.
  • Multiple INSERTs are added in a single query, which is quite fast. Number of INSERTs per second will depend on MySQL configuration settings (the defaults are not optimised), datatype / length inserted, system load, operating system, hardware etc.


Ensure the database already exists in MySQL e.g. for the test schema:

    mysql -u root -p < test.sql

Adjust the array connection details and parameters in the file databasefiller_example.php

Then execute this file with PHP on the command-line:

    php databasefiller_example.php

or run the file through a web server e.g.



Database Filler is released under the GPL v.3.

  Files folder image Files  
File Role Description
Files folder imageclasses (1 file)
Accessible without login Plain text file databasefiller_example.php Example Example script
Accessible without login Plain text file LICENSE Lic. Auxiliary data
Accessible without login Plain text file Doc. Auxiliary data
Accessible without login Plain text file test.sql Data Auxiliary data

  Files folder image Files  /  classes  
File Role Description
  Plain text file databasefiller.class.php Class Class source

 Version Control Unique User Downloads Download Rankings  
This week:0
All time:6,803
This week:279Up
User Comments (1)
3 years ago (muabshir)

For more information send a message to info at phpclasses dot org.