A PHP command line application to dump databases into your source code. This can be very useful if you need to version control your database along with the source code.
This package is available on packagist. You can use following commands to add this package into your composer dev dependancies.
composer require srimaln91/sql-dumper --dev
You need to have mysql and mysqldump binaries installed on your system. This package uses native mysql binaries to create and restore dumps.
Please follow below steps to configure this application.
composer require srimaln91/sql-dumper --dev
You need to create a config.yml file in your project root. Below is the default config file.
---
database:
hostname: localhost
database: xxxxx
username: xxxxx
password: xxx
port: 3306
binaries:
mysql: "/usr/bin/mysql"
git: "/usr/bin/git"
directory:
db: "/path/to/your/dump/directory/"
You can execute below command to create a new dump or update an existing dump directory
vendor/bin/application db:dump
Please use below command
vendor/bin/application db:restore
See also the list of contributors who participated in this project.
This project is licensed under the MIT License - see the LICENSE.md file for details