Knowledge base
Search…
Knowledge base
Goal of knowledge base
Linux & core
Linux
Core services
Hardware
Database
MySQL
InnoDB - innodb_file_per_table parameter
MySQL - enable slow query log
MySQL - export large tables
MongoDB
Container
Docker
Podman
Automation
Ansible
Build & Deployment
Jenkins
Language & Toolset
PHP
Mindset
Technical based
Non-technical based
Reference & learning source
Books
English
Powered By
GitBook
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!
Previous
MySQL - enable slow query log
Next - Database
MongoDB
Last modified
2yr ago
Copy link
Contents
1. Goal
2. Implementation