Backwork plug-in for MySQL backups.
Project description
backwork-backup-mysql
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
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
Hashes for backwork-backup-mysql-0.3.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 12ce8212daa536b61caf5fefe7d8446824bdc8147bcc6c2c048f5029d40ee406 |
|
MD5 | 8018b95975424f128e1d119d9a888fc8 |
|
BLAKE2b-256 | 997fe3ecdb47a2117e70ecf82954a0d4aa823be5443ffef8c868eeb13bd56642 |