This is a php version of mysqldump cli that comes with MySQL, without dependencies, output compression and sane defaults. Out of the box, MySQLDump-PHP supports backing up table structures, the data itself, views, triggers and events. MySQLDump-PHP is the only library that supports output binary blobs as hex. Resolves view dependencies (using Stand-In tables). Output compared against original mysqldump. Linked to travis-ci testing system (testing from php 5.3 to 7.3 & hhvm). Dumps stored routines (functions and procedures). Dumps events, does extended-insert and/or complete-insert, supports virtual columns from MySQL 5.7, does insert-ignore, like a REPLACE but ignoring errors if a duplicate key exists, modifying data from database on-the-fly when dumping, using hooks. Can save directly to google cloud storage over a compressed stream wrapper (GZIPSTREAM).
Features
- Requires PHP 5.3.0 or newer
- Requires MySQL 4.1.0 or newer
- Table specific export conditions
- Table specific export limits
- Constructor and default parameters
- Supports virtual columns from MySQL 5.7