I'd like to call mysqldump to create multiple backup files and then archive them in one tar.gz.
I am following this tutorial on mysqldump part: http://dev.mensfeld.pl/2013/04/backup-mysql-dump-all-your-mysql-databases-in-separate-files/ (at the end, it calls mysqldump in a loop for every database and creates one file at a time)
I can just save all files in temporary directory and 'then' put them into the archive, however, is there anyway how to skip this unnecessary temporary-directory part? I tried to learn about named pipes, thinking they may be what I need, however, haven't really understood them.