10 Ways to Automatically and Manually Backup MySQL Database

MySQL is one of the most popular open source database management system for the development of interactive Websites.

If your site stores its sensitive data in a MySQL database, you will most definitely want to backup that information so that it can be restored in case of any disaster (we all have been there).

There are several ways to backup MySQL data. In this article we’ll look at how to backup your databases using different methods, we will also learn how to achieve an automatic backup solution to make the process easier. Starting with the mysqldump utility that comes with MySQL, we will review several examples using mysqldump, including the backup of your database to a file, another server, and even a compressed gzip file and send it to your email .

1. Automatically backup mysql database to Amazon S3

2. Backup MySQL Database automatically (for Linux users)

3. Backup your MySQL databases automatically with AutoMySQLBackup

4. Backing Up With MySQLDump

5. Backup Your Database into an XML File Using PHP

6. Using PHP To Backup MySQL Database

7. Backup MySQL Database Via SSH

8. E-mail yourself an automatic backup of your MySQL database table with PHP

9. Ubuntu Linux Backup MySQL server Shell Script

10. Backup MySQL databases, web server files to a FTP server automatically

Read more http://blogmee.info/index.php/10-ways-to-automatically-and-manually-backup-mysql-database/