MySQL Dumper

Create MySQL dumps and upload to Dropbox, remote FTP server or Amazon S3.

Installation

Get the latest version of mysqldumper.phar. Use cURL to grab it directly on your server, or download the latest binary from Releases.

curl -OL https://github.com/JayBizzle/mysqldumper/releases/download/1.0.5/mysqldumper.phar

Then create a mysqldumper.json in the same directory as the phar and enter your own settings.

Options

  --dir=DIR                    The directory to output the mysql dumps [default: "archive"]
  --keep-local                 Keep local dumps when backup is complete
  --skip-remote                Skip uploading files to remote
  --ignore-table=IGNORE-TABLE  Skip tables during dump (multiple values allowed)
  --self-update                Check for, and update to latest version

Settings

Setting | Description ------------- | ------------- mysqldump | The full path to to mysqldump db_host | Database hostname db_user | Database username db_pass | Database password keepfor | How long to keep the remote backups (any string that can be parsed by strtotime can be used) driver | dropbox, ftp or s3

Dropbox specific settings

Setting | Description ------------- | ------------- accesstoken | Dropbox access token appsecret | Dropbox app secret

Visit https://www.dropbox.com/developers/apps and get your "App Secret" and "Access Token".

FTP specific settings

Setting | Description ------------- | ------------- ftp_host | FTP hostname ftp_user | FTP username ftp_pass | FTP password ftp_port | FTP Port (Optional. Default 21) ftp_root | FTP root path (Optional. Default ./) ftp_passive | Use passive mode (Optional. Default true) ftp_ssl | Use SSL (Optional. Default true) ftp_timeout | Connection timeout (Optional. Default 30)

Amazon S3 specific settings

Setting | Description ------------- | ------------- s3_bucket | Bucket name s3_key | Your key s3_secret | Your secret s3_region | S3 region

See here to find out how to obtain your S3 key and secret.

Usage

As an example, you could run mysqldumper every x hours using a cron job with a command like this:

/usr/local/bin/php mysqldumper.phar --ignore-table=my_first_table --ignore-table=my_second_table >/dev/null 2>&1

Dropbox

mysqldumper.json

{
  "mysqldump": "/path/to/mysqldump",
  "db_host": "HOSTNAME",
  "db_name": "DATABASE",
  "db_user": "USER",
  "db_pass": "PASSWORD",
  "keepfor": "7 days",
  "driver": "dropbox",
  "accesstoken": "ACCESSTOKEN",
  "appsecret": "APPSECRET"
}

Visit https://www.dropbox.com/developers/apps and get your "App Secret" and "Access Token".

FTP

mysqldumper.json

{
  "mysqldump": "/path/to/mysqldump",
  "db_host": "HOSTNAME",
  "db_name": "DATABASE",
  "db_user": "USER",
  "db_pass": "PASSWORD",
  "keepfor": "7 days",
  "driver": "ftp",
  "ftp_host": "ftp.domain.com",
  "ftp_user": "USERNAME",
  "ftp_pass": "PASSWORD"
}

Amazon S3

mysqldumper.json

{
  "mysqldump": "/path/to/mysqldump",
  "db_host": "HOSTNAME",
  "db_name": "DATABASE",
  "db_user": "USER",
  "db_pass": "PASSWORD",
  "keepfor": "7 days",
  "driver": "s3",
  "s3_bucket": "BUCKETNAME",
  "s3_key": "KEY",
  "s3_secret": "SECRET",
  "s3_region": "REGION"
}

See here to find out how to obtain your S3 key and secret.