mysqldump '-add-drop-table' '-uroot '-ppassword' 'mydatabase' '|' 'gzip' '-9c' '>' "$backup_dir/mydatabase.sql.gz"