MySQL data to Laravel seed

mysql-to-laravel-seed on Github

We had a Laravel application, one team member was using an old version of the application for inserting data through the user interface, at the same time we were developing all kind of changes in the database schema, and the application in general, sadly most of the migrations were not unitary and the changes were performed in a single initial migration file.

Then we were provided with an SQL dump file with the data and we had to include this new data set in our application version for testing them.

That's why I've developed this simple script available in github, that takes a MySQL database and a descriptive schema file as an input and create seed files with the data matching the existing data in the database with the data described in the schema.

When there is data in the schema that is not present on the database it will insert empty values so you may need to review some files with your favorite text editor.