WordPress: Backing up Database Using mysqldump on the Command Line
View Database Config*
cat /var/www/wp-config.php | grep DB
* Path to wp-config.php may be different.
Export Database
mysqldump --no-tablespaces -u wordpress_user -p wordpress | xz -9ec > wordpress_20190520.sql.xz
List Backup Files
ls -l
Scan Through Compressed Database
xzless wordpress_20190520.sql.xz
Hose Bibb Faucet Aerator
Plumb Pak PP800-17 Faucet Aerator, 3-3/4 in H X 1-7/8 in W: https://amzn.to/2LYXPhg (Amazon affiliate)