/docker-php-mysqldump

Dump MySQL databases without using mysqldump command

Primary LanguageDockerfileMIT LicenseMIT

Docker PHP-MySQLdump

Dockerization of PHP MySQLdump library ifsnop/mysqldump-php.

Repository URL

Github.com Docker Hub

Usage

First download the image.

docker pull ahabid/php-mysqldump:1.0.1

Create an env file (See environments section).

Run the image using docker run.

docker run --rm -it \
    --env-file=/path/to/env-file.env \
    -v /host/path/to/store:/var/www/html/storage \
    ahabid/php-mysqldump:1.0.1

IMPORTANT: Make sure your host storage path is writable.

Environments

PHP-INI

Name Description
PHP_INI_OUTPUT_BUFFERING Output buffering value.
Default Value: 4096
PHP_INI_ZLIB_OUTPUT_COMPRESSION Toggle ZLIB Output Compression value.
Default Value: Off
PHP_INI_MAX_EXECUTION_TIME Max time PHP will be executed.
Default Value: 60
PHP_INI_MAX_INPUT_TIME Max time PHP will wait for input.
Default Value: 60
PHP_INI_MEMORY_LIMIT Max memory limit used by PHP process.
Default Value: 256M
PHP_INI_DISPLAY_ERRORS Toggle display errors.
Default Value: Off
PHP_INI_DISPLAY_STARTUP_ERRORS Toggle display errors on startup.
Default Value: Off
PHP_INI_ERROR_LOG PHP Error log path
Default Value: (blank)
PHP_INI_POST_MAX_SIZE Max data size available for POST requests.
Default Value: 2M
PHP_INI_FILE_UPLOADS Toggle enable file uploading.
Default Value: On
PHP_INI_UPLOAD_MAX_FILESIZE Max upload file size.
Default Value: 2M
PHP_INI_MAX_FILE_UPLOADS Max number of files can be uploaded during a request.
Default Value: 2
PHP_INI_ALLOW_URL_FOPEN Toogle allow URL to use by fopen function.
Default Value: On
PHP_INI_DATE_TIMEZONE Timezone for PHP Datetime.
Default Value: UTC
PHP_INI_SESSION_SAVE_HANDLER Session save handler name.
Default Value: files
PHP_INI_SESSION_SAVE_PATH Session save path.
Default Value: /tmp
PHP_INI_SESSION_USE_STRICT_MODE Toggle session strict mode.
Default Value: 0
PHP_INI_SESSION_USE_COOKIES Toggle use of session cookies.
Default Value: 1
PHP_INI_SESSION_USE_ONLY_COOKIES Toggle use of only session cookies.
Default Value: 1
PHP_INI_SESSION_NAME Name of session.
Default Value: APP_SSID
PHP_INI_SESSION_COOKIE_SECURE Cookies available for HTTPS only.
Default Value: On
PHP_INI_SESSION_COOKIE_LIFETIME Cookies lifetime in seconds. 0 for until browser is closed.
Default Value: 0
PHP_INI_SESSION_COOKIE_PATH Cookies usage URI path.
Default Value: /
PHP_INI_SESSION_COOKIE_DOMAIN Cookies usage domain.
Default Value: ``
PHP_INI_SESSION_COOKIE_HTTPONLY Cookies to be used by HTTP only.
Default Value: On
PHP_INI_SESSION_COOKIE_SAMESITE Read here.
Default Value: ``
PHP_INI_SESSION_UPLOAD_PROGRESS_NAME Name of session for file upload progress.
Default Value: APP_UPLOAD_PROGRESS
PHP_INI_OPCACHE_ENABLE Toggle enable opcache for WEB.
Default Value: 1
PHP_INI_OPCACHE_ENABLE_CLI Toggle enable opcache for CLI.
Default Value: 0
PHP_INI_OPCACHE_MEMORY_CONSUMPTION Opcache memory consumption in MB.
Default Value: 256
PHP_INI_OPCACHE_INTERNED_STRINGS_BUFFER Opcache memory used to store interned strings, in megabytes.
Default Value: 16
PHP_INI_OPCACHE_MAX_ACCELERATED_FILES Max no. of files to opcache.
Default Value: 100000
PHP_INI_OPCACHE_MAX_WASTED_PERCENTAGE Max wasted percentage.
Default Value: 25
PHP_INI_OPCACHE_USE_CWD Appends current working directory to script key if enabled.
Default Value: 0
PHP_INI_OPCACHE_VALIDATE_TIMESTAMPS Validate file's timestamps for modification after given no. of seconds.
Default Value: 0
PHP_INI_OPCACHE_REVALIDATE_FREQ Re-validate frequency.
Default Value: 0
PHP_INI_OPCACHE_SAVE_COMMENTS Save comments for opcached files.
Default Value: 0
PHP_INI_OPCACHE_ENABLE_FILE_OVERRIDE Toggle enable file override.
Default Value: 1
PHP_INI_OPCACHE_MAX_FILE_SIZE Max size of file to be cacheable.
Default Value: 0
PHP_INI_OPCACHE_FAST_SHUTDOWN Opcache Fast Shutdown.
Default Value: 1

MySQL Dump

Name Description
DB_HOST Database host name
Default Value: localhost
DB_PORT Database port number
Default Value: 3306
DB_USER Database user name
Default Value: root
DB_PASS Database user password
Default Value: secret
DB_NAME Database name
Default Value: dbname
STORAGE_LOCATION Folder location to store the dump files.
Default Value: /var/www/html/storage/
STORAGE_FILENAME Filename of the stored file. If set to blank, will auto generate name using format dbname_Y_m_d_H:i:s.sql.
Default Value: filename.sql
DUMP_INCLUDE_TABLES Include tables in the dump, separated by comma.
Default Value: ``
DUMP_EXCLUDE_TABLES Exclude tables from the dump, separated by comma.
Default Value: ``
DUMP_INIT_COMMANDS Run commands at startup, separated by comma
Default Value: ``
DUMP_COMPRESS Compress the dump. Options are None, Gzip, Bzip2, Gzipstream.
Default Value: None
DUMP_DEFAULT_CHARACTER_SET Default character set. Options are utf8, utf8mb4.
Default Value: utf8mb4
DUMP_NET_BUFFER_LENGTH Set net buffer length.
Default Value: 1000000
DUMP_NO_DATA Create dump with no row data if set to true. Useful when need to create dump with structures only.
Default Value: false
DUMP_CREATE_IF_NOT_EXISTS Not Working Add CREATE TABLE IF NOT EXISTS command.
Default Value: true
DUMP_RESET_AUTO_INCREMENT Reset auto increment value to 1.
Default Value: false
DUMP_ADD_DROP_DATABASE Add the DROP DATABASE command.
Default Value: false
DUMP_ADD_DROP_TABLE Add the DROP TABLE command.
Default Value: true
DUMP_ADD_DROP_TRIGGER Add the DROP TRIGGER command.
Default Value: true
DUMP_ADD_LOCKS Add the LOCK/UNLOCK TABLE command.
Default Value: false
DUMP_COMPLETE_INSERT Add inserts with full column names.
Default Value: false
DUMP_DISABLE_KEYS Disable Keys
Default Value: false
DUMP_EXTENDED_INSERT Add extended inserts for faster multiple data inserts on import.
Default Value: false
DUMP_EVENTS Dump Events.
Default Value: false
DUMP_HEX_BLOB Dump Hex Blob.
Default Value: false
DUMP_INSERT_IGNORE Add Insert with IGNORE command.
Default Value: false
DUMP_NO_AUTOCOMMIT No Auto Commit.
Default Value: false
DUMP_NO_CREATE_INFO Do not add CREATE TABLE command.
Default Value: false
DUMP_LOCK_TABLES Add Lock/Unlock Tables
Default Value: false
DUMP_ROUTINES Dump Routines.
Default Value: false
DUMP_SINGLE_TRANSACTION Use Single Transaction.
Default Value: false
DUMP_SKIP_TRIGGERS Skip Triggers.
Default Value: false
DUMP_SKIP_TZ_UTC Skip TZ UTC ??.
Default Value: false
DUMP_SKIP_COMMENTS Skip Comments.
Default Value: false
DUMP_SKIP_DUMP_DATE Skip Dump Table.
Default Value: false
DUMP_SKIP_DEFINER Skip Definer.
Default Value: false
PDO_PERSISTENT_CONNECTION Use PDO Persistent Connection.
Default Value: false
PDO_MYSQL_USE_BUFFERED_QUERY Use PDO MySQL Buffered Query.
Default Value: true