fadeevms/yii2-dump-db

dump db for Yii2

Yii2 extension that allows to create backups of mysql database (structure and data)

Installation

The preferred way to install this extension is through composer., _(*1)

Either run, _(*2)

php composer.phar require --prefer-dist fadeevms/yii2-dump-db "*"

or add, _(*3)

"fadeevms/yii2-dump-db": "*"

to the require section of your composer.json., _(*4)

To use this extension, simply add the following code in your application configuration:, _(*5)

    'components' => [
        ...
        'dumper' => [
            'class' => 'fadeevms\dump\dumpDB',
        ],
        ...
    ],

Usage:, _(*6)

      $dumper = \Yii::$app->dumper;
      echo $dumper->getDump();

Saving the dump to a file:, _(*7)

      $dumper = \Yii::$app->dumper;
      $bk_file = 'FILE_NAME-'.date('YmdHis').'.sql';
      $fh = fopen($bk_file, 'w') or die("can't open file");
      fwrite($fh, $dumper->getDump(FALSE));
      fclose($fh);

Dumping external DB:, _(*8)

     $dumper = new \fadeevms\dump\dumpDB('mysql:host=HOTS_NAME_OR_IP;dbname=DATABASE_NAME','USERNAME','PASSWORD');
     $dumper->setRemoveViewDefinerSecurity(TRUE);
     echo $dumper->getDump();