dumpling

Create SQL dumps from MySQL-compatible databases with ease

brewmacoslinux

Try with needOr install directly

About

Creating SQL dump from a MySQL-compatible database

dumpling

Dump all databases from a local MySQL server$ dumpling -u root -p password -h 127.0.0.1 -P 3306 -o ./dump

Dump specific database with multiple threads$ dumpling -u root -p password -B mydb -t 4 -o ./dump

Dump specific tables with compression$ dumpling -u root -p password -B mydb -T table1,table2 -o ./dump --compress gzip