Try this: mysqldump -u root -p –all-databases | zip [email protected] /var/www/html/db-$(date +%F-%T).zip …

Ubuntu VPS Hosting via mysqldump a zipped dump.