Cron Job for backing up multiple dbs at once
Right now I use below script to get a full backup of a db
mysqldump --opt -Q -u DATABASEUSER --password=PASSWORD -h DBHOST DBNAME | gzip > /home/524124/arcade.gz
But now i have so many dbs and my hosting allows only 5 cron jobs. So I have to either write a .sh to execute which will get a backup of each DB in order and one after each other. Not all at the same time.
I have to come up with one command which will get backups of all DBs but right after each other. Not all at the same time.
Can somebody help me please?