Backwork plug-in for MySQL backups.
Project description
monsoon-backup-mysql
Add support for MySQL backups on monsoon
.
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 from Artifactory.
First you will need to configure your pip client by creating or editing the
~/.pip/pip.conf
file to look like this:
[global]
index-url = https://pypi.python.org/simple
extra-index-url = https://<USERNAME>:<API KEY>@na.artifactory.swg-devops.com/artifactory/api/pypi/apset-pypi-local/simple
After that you should be able to run
$ pip install monsoon-backup-mysql
Alternatively, you can install it directly from GHE:
$ pip install git+ssh://git@github.ibm.com/apset/monsoon-backup-mysql
Using
After installing the plug-in you will be able to use the backup mysql
command
on monsoon
.
$ monsoon backup mysql -h
usage: monsoon 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
:
$ monsoon 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.
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
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for backwork-backup-mysql-0.1.7.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | a86d5730b6e29718539cded8ee413aa448989044a5953ad48d483f09ab9746c0 |
|
MD5 | afb1ce4d10100165334890821c56a6e6 |
|
BLAKE2b-256 | 017dea393e5eb92da36850111d391c48f9a3bfd9a6f4b0f0cbc24ffcddeeefd2 |
Hashes for backwork_backup_mysql-0.1.7-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 705568e42247e87af397a4f334f1a00c703b855db9324b7093ad43a1d9a5c5a3 |
|
MD5 | 6a5c5490bf776a9d24a49ce1b9433558 |
|
BLAKE2b-256 | 919261dfed6f26bec7b9cabf635eb5a17c2d195a2bbface17f6aadb902fa53c1 |