Hanya untuk catatan

Backup

mysqldump -u{user} -p {database} > {database}.sql

Restore

mysql -u user -p databasename < backupname.sql

With Compress je Backup

mysqldump -u {user} -p {database} | gzip > {database}.sql.gz

Restore

gzip -dc < {database}.sql.gz | mysql -u {user} -p {database}

With CronJ

mysqldump -u {user} -p {database} | gzip > `date -I`.database.sql.gz
gzip -dc < `date -I`.{database}.sql.gz | mysql -u {user} -p {database}