DUMPS

As time goes by, migrations will be immense. We need to shrink it down, and dump is the answer for that. We have dumps to clear out migrations while migration schemas is dump in a .sql file that will be soon loaded as we migrate or need a fresh database environment.

In config.php the mysql_path help the dump to do it's thing correctly, beacause if we forgot to set the mysql_path, we cannot dump the database correctly that's why we need to locate our mysql/bin to tell the dump that we are using the mysql to dump the database.

The process of the dumps:

• ensure database repository exist

• we get the completed migrations on our database repository base on the last batch number

• then we build the schema of the completed migrations

• after that, we remove the migrations from the database repository

• and dump the schme to a .sql file