Backup all mysql databases to individual files on a remote server

 

$ for I in $(mysql -e 'show databases' -u root --password=root -s --skip-column-names); do mysqldump -u root --password=root $I | gzip -c | ssh This email address is being protected from spambots. You need JavaScript enabled to view it. "cat > /remote/$I.sql.gz"; done