Learning logs in Aug
- Export large tables in MySQL
- Bash completion on debian 9
Table of Contents
1. Export large tables in MySQL
- Large tables
- Progress
- Compression
tmux new -s exporting
mysqldump -udevops -pxxxxxx -hhost.xxxx \
dbname table1 table2 table3 | pv | gzip -9 > 3tables.sql.gz
2. Bash completion on debian 9
- Autocomplete / hint when pressing tab
- Apply for all user/profile
apt install bash-completion
# In file /etc/profile
if [ -f /etc/bash_completion ]; then
. /etc/bash_completion
fi