Knowledge base
Search…
MySQL - export large tables

1. Goal

Exporting large tables of MySQL database with showing progress and compression output

2. Implementation

1
tmux new -s exporting
2
mysqldump -udevops -pxxxxxx -hhost.xxxx \
3
dbname table1 table2 table3 | pv | gzip -9 > 3tables.sql.gz
Copied!
Last modified 2yr ago
Copy link