webino/webino-db-dump

Database Dump Utility for Zend Framework 2

Database Dump Utility
for Zend Framework 2

, _(*1)

, _(*2)

Utility used to dump a database into a SQL file, and to load that file into a database., _(*3)

Features

• Dump an entire database into a SQL file
• Load a SQL file into a database

Setup

Following steps are necessary to get this module working, considering a zf2-skeleton or very similar application:, _(*4)

1. Run php composer.phar require webino/webino-db-dump:0.1.0, _(*5)

2. Add WebinoDbDump to the enabled modules list, _(*6)

QuickStart

• For example, add this settings to your module config:, _(*7)

  'di' => [
      'instance' => [
          'alias' => [
              'DefaultDbDump' => \WebinoDbDump\Db\Dump\Dump::class,
          ],
      ],
      'DefaultDbDump' => [
          'parameters' => [
              'adapter' => \Zend\Db\Adapter\Adapter::class,
          ],
      ],
  ],

  NOTE: Change the DefaultAdapterDump and \Zend\Db\Adapter\Adapter::class as you wish., _(*8)

• Then, add this code to your controller action:, _(*9)

  // We encourage to use Dependency Injection instead of Service Locator
  $dbDump = $this->getServiceLocator()->get('DefaultDbDump');
  
  // saves the sql code of the entire database to a file
  $dbDump->save('example/dump.sql');
  
  // drops & creates tables/views, triggers and inserts the data
  $dbDump->load('example/dump.sql');

  NOTE: If you don't know how to inject the WebinoDbDump into action controller, check out test/resources., _(*10)

  NOTE: Use stream wrappers, e.g. compress.zlib://example.dump.sql.gz, if you want compression., _(*11)

Changelog

0.1.0

• Initial release

Develop

, _(*12)

We will appreciate any contributions on development of this module., _(*13)

Learn How to develop Webino modules, _(*14)

Todo

• Tests
• Add support for more platforms (currently only Mysql)
• Better exceptions
• More options
• Events dump

Addendum

Please, if you are interested in this Zend Framework module report any issues and don't hesitate to contribute., _(*15)

Report a bug | Fork me, _(*16)