Crontab Automated Database Backup using crontab to make automated database

[adly3000 0]

i'd like to make an automated database backup as following:

1- i would like to optimize my databse's tables.
2- I would like to remove any existing backup tarfile.
3- I dump the database to a /tmp file.
4- I tar the database dump and then delete it.

i wrote the following shell:

#!/bin/shrm -rf /tmp/mybackup.sql.tgzmysqldump -uroot -pmypass --opt mybackup > /tmp/mybackup.sql.backupcd /tmp/tar -zcvf mybackup.sql.tgz mybackup.sql.backuprm -rf /tmp/mybackup.sql.backup

[adly3000 0]

in my crontab command i wrote:

GET /home/adly3000/tmp/mkbackup.sh

[adly3000 0]

please any help would be appricated. help me.any suggestions!!!