MySQL

Comandos para MySQL que he repetido toda la vida y no voy a memorizar

# Dump
mysqldump --set-gtid-purged=OFF -h [host] -P [port] -u [user] -p [database] > ~/Downloads/[filename].sql

# Restore
mysql -u [user] -p [database] < ~/Downloads/[filename].sql

# Export CSV
mysql -u [user] -p [database] -h [host] -P [port] -e "[query]" | tr '\t' ',' > ~/Downloads/[filename].csv