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.
Visualisation of backups distribution in time
The recommended way to install this library is to use Composer.
php composer.phar install clevis/database-backup
$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:
$mysqli = $dibiConnection->getDriver()->getResource();
You can customize the created dumps by configuring the
Do not dump table
$dumper->tables['foo'] = $dumper::NONE;
Dump only structure, but not data of table
// CREATE TABLE `foo` (...) $dumper->tables['foo'] = $dumper::CREATE; // DROP TABLE `foo` IF EXISTS + CREATE TABLE `foo` (...) $dumper->tables['foo'] = $dumper::CREATE | $dumper::DROP;
Dump only some rows in table
$dumper->setCustomDataSelect('foo', 'SELECT * FROM `foo` WHERE `bar` = 1');
Do not lock tables while dumping tables:
For more examples see documentation of Clevis/MySQLDump library.