Skip to main content

Backwork plug-in for MySQL backups.

Project description

backwork-backup-mysql Build Status PyPI version

Add support for MySQL backups on backwork.

Requirements

This plug-in is build on top of mysqldump, so you will need to it installed.

mysqldump is part of the mysql client.cd .

Installing

You can use pip to install this plug-in:

$ pip install backwork-backup-mysql

Using

After installing the plug-in you will be able to use the backup mysql and restore mysql commands on backwork:

backwork backup mysql

$ backwork backup mysql -h
usage: backwork backup mysql [-h] [--gzip] [-o OUTPUT]

Backup a MySQL database. It uses `mysqldump` so it's required to have it
installed and added to the system's PATH. You can use any of the arguments
supported by `mysqldump`. Use `mysqldump -h` for more information.

optional arguments:
  -h, --help            show this help message and exit
  --gzip                compress output file  (requires gzip to be installed)
  -o OUTPUT, --output OUTPUT
                        output file path

You can pass any option that you would normally use on mysqldump:

$ backwork backup mysql --host 192.168.99.1 -u root -ppassword --port 32769 --all-databases

As shown in the --help message, there are two extra arguments you can use in your backup process --gzip and -o.

--gzip will compress the output and requires the gzip command to be available in your system.

-o OUTPUT or --output OUTPUT will save the output of mysqldump into a file.

backwork restore mysql

usage: backwork restore mysql [-h] [--gzip] [-i INPUT]

Restore MySQL databases. It uses `mysql` so it's required to have it
installed and added to the system's PATH.

optional arguments:
  -h, --help            show this help message and exit
  --gzip                decompress backup file before restoring (requires gzip to be installed)

You can pass any option that you would normally use to connect to your mysql instance:

$ backwork restore mysql --host 192.168.99.1 -u root -ppassword --port 32769 --gzip --input=="mybackup.archive.gz"

Important: There is a conflict with the -h argument since it is reserved for the help/usage message. User --host to pass the hostname.

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for backwork-backup-mysql, version 0.3.0
Filename, size File type Python version Upload date Hashes
Filename, size backwork-backup-mysql-0.3.0.tar.gz (4.3 kB) File type Source Python version None Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page