Mydumper allows you:
- To make dumps of MySQL databases
- Automaticaly remove outdated or unnecessary of stored dumps
Is recommended to install mydumper with pip and virtualenv, but you can also use any other method of Python package installing.
$ pip install mydumper
$ git clone git://github.com/rdolgushin/mydumper.git
$ pip install -e mydumper/
$ mydumper
usage: mydumper -u USER [-p PASSWORD] [-h HOST] -d DUMP_DIR
[-m MAX_DUMPS_QTY] [-M MAX_DAYS_DELTA]
database
$ mydumper -u john -p secret -m 10 -M 3 test_db
Crontab example:
0 */1 * * * * /home/john/.virtualenvs/default/bin/mydumper -u john -p secret -m 10 -M 3 test_db