Requirements 1. We will need a script which will backup our db 2. We need to set a cron job which will run this script at regular intervals. The script we will be using it is AutoMySQLBackup,search it on Google, it's free. Now what this script will do: Every day AutoMySQLBackup will run will dump your specified databases to the /backups/daily directory, it will rotate daily backups weekly so you should never have more than 7 backups in there.. Every Saturday AutoMySQLBackup will again backup the databases you have chosen but they will be placed into /backups/weekly, these will be rotated every 5 weeks so there should never be more than 5 backups in there.. Every 1st of the month AutoMySQLBackup will create a backup of all databases and place them into /backups/monthly. These will never be rotated so it will be up to you to do your own house keeping. I would suggest taking a copy of these DB backups offline every month or two so that if you have a hard drive failure you will be able to restore your database.. Now the editing part, divided in two stages: Part 1 1. Now after downloading AutoMySQLBackup, place it in your web directory OUTSIDE public_html so that nobody can access it except yours ex. backups 2. Edit (at least) the following lines :- USERNAME=dbuser (The user must have at least select privileges to the databases) PASSWORD=password DBNAMES="DB1 DB2 DB3" (make sure to keep the quotes " " otherwise it won't work) [In case you are using it for mybb forum db, it should be only the name of your forum db and i recommend to use it for that only] 3. Make the file executable :- chmod u+rwx (755) Part 2 Now we need to set a cron job which will run it at a specified time: (to know how to set it please read Here) I am just providing here the most important part, command line (only this which many of you don't know to write it). In the cron command line, write Quote:/bin/sh /home/[your username]/backups/automysqlbackup.sh and save it to run once daily.