MySQL - export large tables

1. Goal
Exporting large tables of MySQL database with showing progress and compression output
2. Implementation
tmux new -s exporting
mysqldump -udevops -pxxxxxx -hhost.xxxx \
           dbname table1 table2 table3 | pv | gzip -9 > 3tables.sql.gz

MySQL - enable slow query log

Next - Database

MongoDB

Last updated 1 year ago