PHP download

Download the PHP package cytopia/mysqldump-secure without Composer

On this page you can find all versions of the php package cytopia/mysqldump-secure. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download cytopia/mysqldump-secure
More information about cytopia/mysqldump-secure
Files in cytopia/mysqldump-secure

Vendor cytopia
Package mysqldump-secure
Short Description Secure mysqldump script with encryption, compression, logging, blacklisting and Nagios monitoring integration
License MIT
Homepage https://github.com/cytopia/mysqldump-secure

Keywords database dump mysql encryption export backup mysqldump

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.

Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
To use Composer is sometimes complicated. Especially for beginners.
Composer needs much resources. Sometimes they are not available on a simple webspace.
If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.

Please rate this library. Is it a good library?

Informations about the package mysqldump-secure

mysqldump-secure

ATTENTION

Please upgrade to the latest version in order to be notified about the OpenSSL SMIME Bug in case you are affected.

GIT NOTE:

WHEN CLONING VIA GIT, MAKE SURE TO ALWAYS CHECK OUT THE LATEST TAG. THE MASTER BRANCH IS ALWAYS UNDER DEVELOPMENT AND THEREFORE UNSTABLE.

Mysqldump-secure is a POSIX compliant wrapper script for mysqldump with many features and very strong security in mind. It will backup every available database (which is readable by the specified user) as a separate file with the possibility to opt out via blacklisting. Dumped databases can optionally be piped directly to gzip or openssl in order to compress and/or encrypt the backup. Encryption is done before the file is written to disk to avoid possible race conditions (See documentation for more info about security measurements).

Find the project website at https://mysqldump-secure.org Find the whole post at https://www.everythingcli.org

Runs on

_{(If the script runs on any other system not mentioned here, please drop me a note.)}

Rock-stable and well tested

Every push to mysqldump-secure triggers travis-ci which will run hundreds of all kinds of tests against the new code and stress the tool in every possible way with every possible config.

You can find the tests within the test folder including an automated setup to get a master-slave server with SSL encryption setup. Thoses tests can also be run locally.

See https://travis-ci.org/cytopia/mysqldump-secure for checks in action and test for a description about the tests.

1. Features

Primary Features

Encryption (hybrid encryption: RSA and AES via openssl smime - no password needed)
Compression (gzip, pigz, bzip2, pbzip2, lzop, lzma, xz)
Tmpwatch integration (tmpwatch or tmpreaper)
Transaction-safe / Consistent backups across tables (for DBs with: InnoDB only-, mixed- and non-InnoDB- tables)
Conditional mysqldump options (e.g.: apply --quick only on DBs > 200MB)
Security (various built-in checks and precautions)
SSL Remote Backups
Nagios / Icinga monitoring integration (via check_mysqldump-secure)

Secondary Features

Custom mysqldump options
Master/Slave recognition
Blacklisting
Whitelisting
File logging
Self validation
Rock stable (see travis for hundreds of checks)
100% POSIX compliant

2. Installation

2.1 Linux, BSD and OSX

2.2 OSX

For more detailed instructions go to the Install guidelines

3. Configuration

There are two separate configuration files:

/etc/mysqldump-secure.cnf
/etc/mysqldump-secure.conf

The first one is to setup the MySQL credentials and the second one configures the behavior of how to backup the databases.

You do not need to worry about file permissions or directories. The script will auto-check the following options and adjust them as required:

Logfile exists
Logfile is writeable
Auto creation of logfile
Logging turned off automatically
Destination dir exists
Destination dir is writeable
Auto creation of destination dir
Required system binaries exist
MySQL credentials are valid

For more detailed instructions go to the Setup guidelines

4. Usage

4.1 Usage

4.2 Default

Test if everything is configured correctly:

Manual run from commmand line:

Run from within cron

4.3 Custom config

It is possible to have multiple instances of mysqldump-secure on your machine via different config files. Imagine the case you want to have some sensitive dumps encrypted and others should be dumped in plain. You can achieve this by using two configuration files and the IGNORE blocks of each respective config to exclude the other ones.

Test if everything is configured correctly in the specified config:

Manual run from commmand line:

Run from within cron

4.4 Test run

4.5 Example run

5. Documentation

File	Description
https://mysqldump-secure.org	Project homepage
https://www.everythingcli.org	Blog post: General thoughts and initial idea for this project.
Installation	Different ways to install mysqldump-secure
Requirements	What tools are required to run mysqldump-secure
Configuration	How to configure mysqldump-secure
Security	Information and usage about security measurements
Compression	Information and usage about compression
Encryption	Information and usage about the used encryption
Examples	Some command line examples such as mass importing databases back into the server

6. Contribution

Contributors are welcome.

If the script runs on an operating system productively, which is currently not yet included at the top of this document, please let me know, so I can add it for reference.

If you use the script, star it or let me know somehow.

If you like have a look at the Contributing Guidelines and see if there is anything you would like to take care of.

7. License

8. Version

For a complete list of verion see CHANGELOG

All versions of mysqldump-secure with dependencies

PHP Build Version

Package Version

Version 0.16.5 Release 23. Mar 2022
create-project require 0 people chose require and
0 people chose create-project.

Download

Download latest version of mysqldump-secure from vendor cytopia

No informations.

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package cytopia/mysqldump-secure contains the following files

Loading the files please wait ....