Dockerization of PHP MySQLdump library ifsnop/mysqldump-php.
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.
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 |
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 |