mysqldumper
mysqldumper copied to clipboard
JayBizzle
Create MySQL dumps and upload to Dropbox, remote FTP server or Amazon S3.
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.
JayBizzle