PyDumpy

PyDumpy is a simple tool written in Python that enables easy partial and sorted MySQL database dumping. PyDumpy is perfect when a quick production database snapshot is required with only partial data. Production databases may have hundreds of gigabytes of data which is not always easy or fast to dump and deploy on a development machine.

PyDumpy will dump the whole database by limiting all tables to a default value of 100 000 rows. It also provides a possibility to ask the user which tables to limit and how to sort them before dumping.

Check out the readme page for further details.

Sample Usage

To dump a maximum of 50 000 rows from each database table:

./pydumpy -H localhost -u username -p password -n database -r 50000

To dump a maximum of 10 000 rows from each database table but allowing to override the setting for some tables:

./pydumpy -H localhost -u username -p password -n database -r 50000 --ask-to-limit --file=dump.sql

Dependencies

PyDumpy relies on MySQL for Python package to connect to mysql and query the information schema.

Contribute

All ideas, feature requests and contributions are welcome. Please feel free to contact me or to submit an issue ticket.

Contact

Contact me by emailing me at zilvinas.saltys at gmail dot com.