[lookinto@cpanel64 scripts]$ ls
dumpdemo  dumpSite  dumptest  restoredemo  restoreSite  restoretest
[lookinto@cpanel64 scripts]$ cat dumpdemo
#!/bin/bash

ts=$(date +%F-%T)
mysqldump --user=USER --password=PASSWD DATABASE_NAME | gzip > ~/dumps/DBNAME-$ts.sql.gz
cp ~/dumps/DBNAME-$ts.sql.gz ~/dumps/DBNAME-default.sql.gz
[lookinto@cpanel64 scripts]$ cat restoredemo
#!/bin/bash

gunzip < ~/dumps/DBNAME-default.sql.gz | mysql --user=USER --password=PASSWD DBNAME
[lookinto@cpanel64 scripts]$ ls -la ../dumps/
total 300
drwxrwxr-x  2 lookinto lookinto  4096 Jan  3 12:29 .
drwx--x--x 23 lookinto lookinto  4096 Jan  3 12:39 ..
-rw-rw-r--  1 lookinto lookinto   423 Jan  3 12:27 demo-2009-01-03-12:27:00.sql.gz
-rw-rw-r--  1 lookinto lookinto 41320 Jan  3 12:27 demo-default.sql.gz
-rw-rw-r--  1 lookinto lookinto 52752 Jan  3 12:27 Site-2009-01-03-12:27:03.sql.gz
[lookinto@cpanel64 scripts]$