Server and DB backups are probably the most essential tools needed by any web developer. MySQL db backup is probably the easiest thing to implement if you are running your own server. I have outlined 3 steps to create a DB backup:

• Step 1: Create a directory on your main domain from where you will be downloading the backups, I have called as 'everydayback' created at www.domain.ext/everydaybback
• Step 2: Logon to your server and change your current working directory to /usr/bin and create a new file called as 'dbback.sh'. You can do this by typing 'vi dbback.sh'
• Step 3: Copy the commands from the text area below replacing your MySQL 'root' username and password, save dbback.sh by typing ':' and 'wq'