Requirements | Installing | Getting started | API | Settings | PDO Settings | TODO | License | Credits

This is a php version of linux's mysqldump in terminal "$ mysqldump -u username -p...", without dependencies, output compression and sane defaults.

Out of the box, MySQLDump-PHP supports backing up table structures, the data itself, views and triggers.

• PHP 5.3.0 or newer
• MySQL 4.1.0 or newer
• PDO

Using Composer:

$ composer require ifsnop/mysqldump-php:1.*

Or via json file:

"require": {
        "ifsnop/mysqldump-php":"1.*"
}

Using Curl:

$ curl --silent --location https://github.com/ifsnop/mysqldump-php/archive/v1.4.1.tar.gz | tar xvfz -

With Autoloader/Composer:

<?php

use Ifsnop\Mysqldump as IMysqldump;

try {
    $dump = new IMysqldump\Mysqldump('database', 'username', 'password');
    $dump->start('storage/work/dump.sql');
} catch (\Exception $e) {
    echo 'mysqldump-php error: ' . $e->getMessage();
}

?>

Plain old PHP:

<?php

    include_once(dirname(__FILE__) . '/mysqldump-php-1.4.1/src/Ifsnop/Mysqldump/Mysqldump.php');
    $dump = new Ifsnop\Mysqldump\Mysqldump( 'database', 'username', 'password');
    $dump->start('storage/work/dump.sql');

?>

Refer to the wiki for some examples and a comparision between mysqldump and mysqldump-php dumps.

/**
 * Constructor of Mysqldump. Note that in the case of an SQLite database
 * connection, the filename must be in the $db parameter.
 *
 * @param string $db         Database name
 * @param string $user       SQL account username
 * @param string $pass       SQL account password
 * @param string $host       SQL server to connect to
 * @param string $type       SQL database type ('mysql', 'sqlite', ...)
 * @param array  $dumpSettings SQL database settings
 * @param array  $pdoSettings  PDO configured attributes
 *
 * @return null
 */
public function __construct(
    $db = '',
    $user = '',
    $pass = '',
    $host = 'localhost',
    $type = 'mysql',
    $dumpSettings = array(),
    $pdoSettings = array()
)

$dumpSettingsDefault = array(
    'include-tables' => array(),
    'exclude-tables' => array(),
    'compress' => 'None',
    'no-data' => false,
    'add-drop-table' => false,
    'single-transaction' => true,
    'lock-tables' => false,
    'add-locks' => true,
    'extended-insert' => true,
    'disable-keys' => true,
    'where' => '',
    'no-create-info' => false,
    'skip-triggers' => false,
    'add-drop-trigger' => true,
    'hex-blob' => true,
    'databases' => false,
    'add-drop-database' => false,
    'skip-tz-utc' => false,
    'no-autocommit' => true,
    'default-character-set' => 'utf8',
    'skip-comments' => false,
    'skip-dump-date' => false,
);

$pdoSettingsDefaults = array(
    PDO::ATTR_PERSISTENT => true,
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
    PDO::MYSQL_ATTR_USE_BUFFERED_QUERY => false
);

// missing settings in constructor will be replaced by default options
$this->_pdoSettings = self::array_replace_recursive($pdoSettingsDefault, $pdoSettings);
$this->_dumpSettings = self::array_replace_recursive($dumpSettingsDefault, $dumpSettings);

• include-tables
  • Only include these tables (array of table names)
• exclude-tables
  • Exclude these tables (array of table names)
• compress
  • Gzip, Bzip2, None.
  • Could be specified using the declared consts: IMysqldump\Mysqldump::GZIP, IMysqldump\Mysqldump::BZIP2 or IMysqldump\Mysqldump::NONE
• no-data
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_no-data
• add-drop-table
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_add-drop-table
• single-transaction
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_single-transaction
• lock-tables
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_lock-tables
• add-locks
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_add-locks
• extended-insert
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_extended-insert
• disable-keys
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_disable-keys
• where
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_where
• no-create-info
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_no-create-info
• skip-triggers
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_triggers
• add-drop-triggers
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_add-drop-trigger
• hex-blob
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_hex-blob
• databases
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_databases
• add-drop-database
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_add-drop-database
• skip-tz-utz
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_tz-utc
• no-autocommit
  • Option to disable autocommit (faster inserts, no problems with index keys)
  • http://dev.mysql.com/doc/refman/4.1/en/commit.html
• default-character-set
  • utf8 (default, compatible option), utf8mb4 (for full utf8 compliance)
  • Could be specified using the declared consts: IMysqldump\Mysqldump::UTF8 or IMysqldump\Mysqldump::UTF8MB4BZIP2
  • http://dev.mysql.com/doc/refman/5.5/en/charset-unicode-utf8mb4.html
  • https://mathiasbynens.be/notes/mysql-utf8mb4
• skip-comments
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_comments
• skip-dump-date
  • http://dev.mysql.com/doc/refman/5.1/en/mysqldump.html#option_mysqldump_dump-date

The following options are now enabled by default, and there is no way to disable them since they should always be used.

• disable-foreign-keys-check
  • http://dev.mysql.com/doc/refman/5.5/en/optimizing-innodb-bulk-data-loading.html

• PDO::ATTR_PERSISTENT
• PDO::ATTR_ERRMODE
• PDO::MYSQL_ATTR_INIT_COMMAND
• PDO::MYSQL_ATTR_USE_BUFFERED_QUERY
  • http://www.php.net/manual/en/ref.pdo-mysql.php
  • http://stackoverflow.com/questions/13728106/unexpectedly-hitting-php-memory-limit-with-a-single-pdo-query/13729745#13729745
  • http://www.php.net/manual/en/mysqlinfo.concepts.buffering.php

To dump a database, you need the following privileges :

• SELECT
  • In order to dump table structures and data.
• SHOW VIEW
  • If any databases has views, else you will get an error.
• TRIGGER
  • If any table has one or more triggers.
• LOCK TABLES
  • If "lock tables" option was enabled.

Use SHOW GRANTS FOR user@host; to know what privileges user has. See the following link for more information:

Which are the minimum privileges required to get a backup of a MySQL database schema?

Current code for testing is an ugly hack. Probably there are much better ways of doing them using PHPUnit, so PR's are welcomed. The testing script creates and populates a database using all possible datatypes. Then it exports it using both mysqldump-php and mysqldump, and compares the output. Only if it is identical tests are OK.

Support connecting through a socket to database. Probably rewrite constructor to support an array with parameters.

Format all code to PHP-FIG standards. http://www.php-fig.org/

This project is open-sourced software licensed under the GPL license

Originally based on James Elliott's script from 2009. http://code.google.com/p/db-mysqldump/

Adapted and extended by Michael J. Calkins. https://github.com/clouddueling

Currently maintained and developed by Diego Torres. https://github.com/ifsnop