Go back to the main page

Using Mydumpers regex switch to only dump certain tables

This article is over 5 years old. Proceed with caution.

Regards ♨ ‐ Minimul


Here is an example of using mydumper's powerful --regex switch.

# Only dump from the issues database tables starting with lowercase a, b, and c. 
mydumper --compress --socket /tmp/mysql.sock -u root -p ***** --regex '^issues\.[a-c]' --verbose 3