srimaln91/sql-dumper

A PHP console application to execute batch of shell commands to versioning wordpress database and source code

SQL Dumper

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., _(*1)

Getting Started

This package is available on packagist. You can use following commands to add this package into your composer dev dependancies., _(*2)

composer require srimaln91/sql-dumper --dev, _(*3)

Prerequisites

You need to have mysql and mysqldump binaries installed on your system. This package uses native mysql binaries to create and restore dumps., _(*4)

Installing

Please follow below steps to configure this application., _(*5)

composer require srimaln91/sql-dumper --dev, _(*6)

Configuration

You need to create a config.yml file in your project root. Below is the default config file., _(*7)

---
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/"
  ```

## How to generate a database dump

You can execute below command to create a new dump or update an existing dump directory

``` vendor/bin/application db:dump ```

### How to restore a database dump

Please use below command

vendor/bin/application db:restore ```, _(*8)

Authors

• Srimal Nishantha - GitHub

See also the list of contributors who participated in this project., _(*9)

License

This project is licensed under the MIT License - see the LICENSE.md file for details, _(*10)