If you're storing anything in MySQL databases that you do not want to lose, it is very important to make regular backups of your data to protect it from loss. This tutorial will show you two easy ways to backup and restore the data in your MySQL database. You can also use this process to move your data to a new web server.
Back up From the Command Line (using mysqldump)
Back up your MySQL Database with Compress
Restoring your MySQL Database
Backing Up and Restoring using PHPMyAdmin