Create and restore MySQL database from compressed backup
How to: Create and restore MySQL database from compressed backup

mysql -uroot -pMYPASSWORD -e "create database c24db" && zcat /mnt/backup/webmin/c24db.sql.gz | mysql -uroot -pMYPASSWORD c24db