In this tutorial you can see how you can create a backup MySQL Database using the MySQLDump utility. This is a task that all MySQL database administrator should know how to handle it. You can also Find the script to automate the MySQL backup here: MySQL Automated Backup Routine