Sign inSign up

ahabid/php-mysqldump

By ahabid

•Updated over 5 years ago

Dockerization of PHP MySQLdump library (ifsnop/mysqldump-php)

Image
0

127

ahabid/php-mysqldump repository overview

⁠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
NameDescription
PHP_INI_OUTPUT_BUFFERINGOutput buffering value.
Default Value: 4096
PHP_INI_ZLIB_OUTPUT_COMPRESSIONToggle ZLIB Output Compression value.
Default Value: Off
PHP_INI_MAX_EXECUTION_TIMEMax time PHP will be executed.
Default Value: 60
PHP_INI_MAX_INPUT_TIMEMax time PHP will wait for input.
Default Value: 60
PHP_INI_MEMORY_LIMITMax memory limit used by PHP process.
Default Value: 256M
PHP_INI_DISPLAY_ERRORSToggle display errors.
Default Value: Off
PHP_INI_DISPLAY_STARTUP_ERRORSToggle display errors on startup.
Default Value: Off
PHP_INI_ERROR_LOGPHP Error log path
Default Value: (blank)
PHP_INI_POST_MAX_SIZEMax data size available for POST requests.
Default Value: 2M
PHP_INI_FILE_UPLOADSToggle enable file uploading.
Default Value: On
PHP_INI_UPLOAD_MAX_FILESIZEMax upload file size.
Default Value: 2M
PHP_INI_MAX_FILE_UPLOADSMax number of files can be uploaded during a request.
Default Value: 2
PHP_INI_ALLOW_URL_FOPENToogle allow URL to use by fopen function.
Default Value: On
PHP_INI_DATE_TIMEZONETimezone for PHP Datetime.
Default Value: UTC
PHP_INI_SESSION_SAVE_HANDLERSession save handler name.
Default Value: files
PHP_INI_SESSION_SAVE_PATHSession save path.
Default Value: /tmp
PHP_INI_SESSION_USE_STRICT_MODEToggle session strict mode.
Default Value: 0
PHP_INI_SESSION_USE_COOKIESToggle use of session cookies.
Default Value: 1
PHP_INI_SESSION_USE_ONLY_COOKIESToggle use of only session cookies.
Default Value: 1
PHP_INI_SESSION_NAMEName of session.
Default Value: APP_SSID
PHP_INI_SESSION_COOKIE_SECURECookies available for HTTPS only.
Default Value: On
PHP_INI_SESSION_COOKIE_LIFETIMECookies lifetime in seconds. 0 for until browser is closed.
Default Value: 0
PHP_INI_SESSION_COOKIE_PATHCookies usage URI path.
Default Value: /
PHP_INI_SESSION_COOKIE_DOMAINCookies usage domain.
Default Value: ``
PHP_INI_SESSION_COOKIE_HTTPONLYCookies to be used by HTTP only.
Default Value: On
PHP_INI_SESSION_COOKIE_SAMESITERead here⁠.
Default Value: ``
PHP_INI_SESSION_UPLOAD_PROGRESS_NAMEName of session for file upload progress.
Default Value: APP_UPLOAD_PROGRESS
PHP_INI_OPCACHE_ENABLEToggle enable opcache for WEB.
Default Value: 1
PHP_INI_OPCACHE_ENABLE_CLIToggle enable opcache for CLI.
Default Value: 0
PHP_INI_OPCACHE_MEMORY_CONSUMPTIONOpcache memory consumption in MB.
Default Value: 256
PHP_INI_OPCACHE_INTERNED_STRINGS_BUFFEROpcache memory used to store interned strings, in megabytes.
Default Value: 16
PHP_INI_OPCACHE_MAX_ACCELERATED_FILESMax no. of files to opcache.
Default Value: 100000
PHP_INI_OPCACHE_MAX_WASTED_PERCENTAGEMax wasted percentage.
Default Value: 25
PHP_INI_OPCACHE_USE_CWDAppends current working directory to script key if enabled.
Default Value: 0
PHP_INI_OPCACHE_VALIDATE_TIMESTAMPSValidate file's timestamps for modification after given no. of seconds.
Default Value: 0
PHP_INI_OPCACHE_REVALIDATE_FREQRe-validate frequency.
Default Value: 0
PHP_INI_OPCACHE_SAVE_COMMENTSSave comments for opcached files.
Default Value: 0
PHP_INI_OPCACHE_ENABLE_FILE_OVERRIDEToggle enable file override.
Default Value: 1
PHP_INI_OPCACHE_MAX_FILE_SIZEMax size of file to be cacheable.
Default Value: 0
PHP_INI_OPCACHE_FAST_SHUTDOWNOpcache Fast Shutdown.
Default Value: 1
⁠MySQL Dump
NameDescription
DB_HOSTDatabase host name
Default Value: localhost
DB_PORTDatabase port number
Default Value: 3306
DB_USERDatabase user name
Default Value: root
DB_PASSDatabase user password
Default Value: secret
DB_NAMEDatabase name
Default Value: dbname
STORAGE_LOCATIONFolder location to store the dump files.
Default Value: /var/www/html/storage/
STORAGE_FILENAMEFilename 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_TABLESInclude tables in the dump, separated by comma.
Default Value: ``
DUMP_EXCLUDE_TABLESExclude tables from the dump, separated by comma.
Default Value: ``
DUMP_INIT_COMMANDSRun commands at startup, separated by comma
Default Value: ``
DUMP_COMPRESSCompress the dump. Options are None, Gzip, Bzip2, Gzipstream.
Default Value: None
DUMP_DEFAULT_CHARACTER_SETDefault character set. Options are utf8, utf8mb4.
Default Value: utf8mb4
DUMP_NET_BUFFER_LENGTHSet net buffer length.
Default Value: 1000000
DUMP_NO_DATACreate 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_EXISTSNot Working Add CREATE TABLE IF NOT EXISTS command.
Default Value: true
DUMP_RESET_AUTO_INCREMENTReset auto increment value to 1.
Default Value: false
DUMP_ADD_DROP_DATABASEAdd the DROP DATABASE command.
Default Value: false
DUMP_ADD_DROP_TABLEAdd the DROP TABLE command.
Default Value: true
DUMP_ADD_DROP_TRIGGERAdd the DROP TRIGGER command.
Default Value: true
DUMP_ADD_LOCKSAdd the LOCK/UNLOCK TABLE command.
Default Value: false
DUMP_COMPLETE_INSERTAdd inserts with full column names.
Default Value: false
DUMP_DISABLE_KEYSDisable Keys
Default Value: false
DUMP_EXTENDED_INSERTAdd extended inserts for faster multiple data inserts on import.
Default Value: false
DUMP_EVENTSDump Events.
Default Value: false
DUMP_HEX_BLOBDump Hex Blob.
Default Value: false
DUMP_INSERT_IGNOREAdd Insert with IGNORE command.
Default Value: false
DUMP_NO_AUTOCOMMITNo Auto Commit.
Default Value: false
DUMP_NO_CREATE_INFODo not add CREATE TABLE command.
Default Value: false
DUMP_LOCK_TABLESAdd Lock/Unlock Tables
Default Value: false
DUMP_ROUTINESDump Routines.
Default Value: false
DUMP_SINGLE_TRANSACTIONUse Single Transaction.
Default Value: false
DUMP_SKIP_TRIGGERSSkip Triggers.
Default Value: false
DUMP_SKIP_TZ_UTCSkip TZ UTC ??.
Default Value: false
DUMP_SKIP_COMMENTSSkip Comments.
Default Value: false
DUMP_SKIP_DUMP_DATESkip Dump Table.
Default Value: false
DUMP_SKIP_DEFINERSkip Definer.
Default Value: false
PDO_PERSISTENT_CONNECTIONUse PDO Persistent Connection.
Default Value: false
PDO_MYSQL_USE_BUFFERED_QUERYUse PDO MySQL Buffered Query.
Default Value: true

Tag summary

Content type

Image

Digest

Size

141.7 MB

Last updated

over 5 years ago

docker pull ahabid/php-mysqldump:1.0.1