dg/mysql-dump

MySQL database dump.

MySQL Dump Utility

This is a backup utility used to dump a database for backup or transfer to another MySQL server. The dump typically contains SQL statements to create the table, populate it, or both., _(*1)

It requires PHP 5.6 (release 1.5) or PHP 7.1 or later., _(*2)

Usage

Create MySQLi object and pass it to the MySQLDump:, _(*3)

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

You can optionally specify how each table or view should be exported:, _(*4)

$dump->tables['search_cache'] = MySQLDump::DROP | MySQLDump::CREATE;
$dump->tables['log'] = MySQLDump::NONE;

Then simply call save() or write():, _(*5)

$dump->save('export.sql.gz');

Import dump from file to database this way:, _(*6)

$import = new MySQLImport($db);
$import->load('dump.sql.gz');

If you like it, please make a donation now. Thank you!, _(*7)