In case you don't have enough examples Here is another version: backup_ragnarok.sh - stores SQL backups in the same directory the script is located (or you can specify a directory) - creates sub-folders named YYYY-MM (ex: 2011-12/) - SQL backup filenames are DBNAME_DATE.sql (ex: ragnarok_2011-12-06_0809.sql) Example cron to create a backup every night at 1:07 am 7 1 * * * /home/rathena/backups-sql/backup_ragnarok.sh