library dbbackup

hgg/dbbackup

Create backup files of databases or individual tables and restore from dump files

No longer maintained! Please use http://github.com/hglattergotz/dbcmd instead, _(*1)

Programmatically create dump files of an entire database or individual tables in a PHP application. Restore from dump files., _(*2)

, _(*3)

Installation

Using Composer:, _(*4)

{
    "require": {
        "hgg/dbbackup": "dev-master"
    }
}

Download source and manually add to project:, _(*5)

• Get the zip file here

Supported Databases:

• MySql

Pull Requests for additional database engines welcome!, _(*6)

Usage

Backup entire database

use HGG\DbBackup\CmdBuilder\MySql;
use HGG\DbBackup\DbBackup;

try
{
    $output = '';
    $backup = new DbBackup(new MySql());
    $backup->backupDb('username', 'password', 'localhost', 'database',
        'backupFile', array(), &$output);

    // log $output
}
catch (\Exception $e)
{
    // deal with failure
}

Backup specific tables in a database

use HGG\DbBackup\CmdBuilder\MySql;
use HGG\DbBackup\DbBackup;

try
{
    $output = '';
    $backup = new DbBackup(new MySql());
    $backup->backupTables('username', 'password', 'localhost', 'database',
        array('table1', 'table2'), 'backupFile', array(), &$output);

    // log $output
}
catch (\Exception $e)
{
    // deal with failure
}

Restore form a dump file

use HGG\DbBackup\CmdBuilder\MySql;
use HGG\DbBackup\DbRestore;

try
{
    $output = '';
    $restore = new DbRestore(new MySql());
    $restore->restore('username', 'password', 'localhost', 'database',
        'backupFile', array(), &$output);

    // log $output
}
catch (\Exception $e)
{
    // deal with failure
}