Title   : Simple Backup Script
Os      : *NiX
Servers : 1. MySql
          2. Ftp
          3. Bash


-- MySql Syntax --

mysql> create database dbname;
mysql> grant all on dbname.* to dbuser@localhost identified by "dbpassword";
mysql> FLUSH PRIVILEGES;
mysql> show databases;
mysql> use dbname;
mysql> show tables;
mysql> drop table tablename;
mysql> drop database dbname;

--- End of MySql Syntax ---

--- dbname-backup.sh ------ 
#!/bin/sh 
DATE=`date +%Y-%m-%d-%H`

mysqldump -udbuser -p dbname > dbname-dump.sql
tar cfj dbname-dump$DATE.tar.bz2 dbname-dump.sql 

ftp -n ftp.xwings.net < < !  
user backup backupasss         
binary                       
put dbname-dump$DATE.tar.gz 
bye 
! 
---- End of dbname-backup.sh ------ 

Everynight 8pm do a backup 

vi /etc/crontab 
00 20 * * 0-6 /path/to/dbname-backup.sh

Note : remember to chmod +x dbname-backup.sh