> For the complete documentation index, see [llms.txt](https://sprnva.gitbook.io/sprnva-docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://sprnva.gitbook.io/sprnva-docs/migration/dumps.md).

# 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