I am always amazed at some of the small things that I think would be easy to find a solution for, seem so ellusive.
Today, I needed to run a quick mysqldump of a 100MB database, and I needed to compress it on the fly to gzip so I did not end up with 2 files on my disc. Just save room and time.
mysqldump -u myusername -h localhost -p dbname | gzip -9 > dbname.sql.gz
Then I get prompted for the username’s password, and there I have it!