> For the complete documentation index, see [llms.txt](https://knowledge.tracelog.in/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://knowledge.tracelog.in/database/mysql/mysql-export-large-tables.md).

# 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
```