clevis/database-backup

DatabaseBackup Tool

Tiny wrapper around Clevis/MySQLDump library which can limit the maximum number of kept backups. The kept backups are efficiently distributed over the whole period of time this tool is being used. The older the backups are the larger time gap is kept between them., _(*1)

Visualisation of backups distribution in time, _(*2)

, _(*3)

Installation

The recommended way to install this library is to use Composer., _(*4)

composer require clevis/database-backup

Basic Usage

$mysqli = new mysqli('localhost', 'root', 'password', 'database');
$dumper = new MySQLDump($mysqli);

// store backups to directory './backups' and keep at most 100 backups
$backup = new Clevis\DatabaseBackup\DatabaseBackup($dumper, __DIR__ . '/backups', 100);
$backup->backupDatabase();

If you use dibi, then you can get the $mysqli object this way:, _(*5)

$mysqli = $dibiConnection->getDriver()->getResource();

Advanced Usage

You can customize the created dumps by configuring the $dumper instance., _(*6)

1. Do not dump table foo:, _(*7)

   $dumper->tables['foo'] = $dumper::NONE;
   

2. Dump only structure, but not data of table foo:, _(*8)

   // CREATE TABLE `foo` (...)
   $dumper->tables['foo'] = $dumper::CREATE;
   
   // DROP TABLE `foo` IF EXISTS + CREATE TABLE `foo` (...)
   $dumper->tables['foo'] = $dumper::CREATE | $dumper::DROP;
   

3. Dump only some rows in table foo:, _(*9)

   $dumper->setCustomDataSelect('foo', 'SELECT * FROM `foo` WHERE `bar` = 1');
   

4. Do not lock tables while dumping tables:, _(*10)

   $dumper->setUseLock(FALSE);
   

5. For more examples see documentation of Clevis/MySQLDump library., _(*11)