filsedla/dbtool

A MySQL database structure dumping tool

v0.3 2016-07-18 12:07 UTC

README

A database structure dumping tool. It dumps tables structure, views, triggers, functions and procedures.

Installation

  1. Add Dbtool to your project using Composer:
$ composer require --dev filsedla/dbtool
  1. Create a script to run dbtool located somewhere inside your project, e.g. <project_root>/tools/db/dbtool.php.

See the example subdirectory for two commented versions, for a nette-based project or other project.

Usage

Manually run the above script each time you update your project's database structure. The idea is to commit complete database structure dumps to your VCS so that the database structure is 'versioned' together with changes in the project code.