10個MySQL數據庫備份教程
MySQL是開發動態交互網站最常用的開源數據庫管理系統。假如你使用MySQL來你網站的后臺數據庫，肯定要經常備份數據以防止丟失。
在這里介紹10個自動或手動備份的MySQL數據庫教程。大家看看有沒有適合你的。
1. Backing Up Using MySQLDump
備份數據可以用 MySQL自帶的mysqldump工具。這里有各種使用mysqldump備份數據的例子，包括：將數據庫備份成一個文件，備份到其它服務器上，甚至壓縮成一個gzip文件。
2. MySQL Export: How to Backup Your MySQL Database?
You can backup by making a dump file (export / backup) of a database used by your account. To do so you have to head over to phpMyAdmin tool in your cPanel.
3. Automatically Backup Mysql Database to Amazon S3
你還可以使用Amazon S3來備份你的mysql數據。在這個教程中提供一個自動化備份腳本，并能夠將備份的mysql文件傳到Amazon S3云存儲中。
4. How to Backup MySQL Databases, Web Server Files to an FTP Server Automatically
It is an easy way to backup data for users who run their own web server and MySQL server on a dedicated box or VPS. The best thing when using FTP or NAS backup is the fact that your data is secure. First of all you have to backup every single database with mysqldump command, Automating tasks of backup with tar, Setup a cron job and create FTP backup script.
5. How to E-Mail Yourself an Automatic Backup of Your MySQL Database Table with PHP
It will deliver an e-mail to you with an .sql file attached, which lets you to back up particular tables easily. You can even create an e-mail account specifically to get these backup.
6. How to Backup MySQL Database Using PHP
Carry out a database backup query from PHP file. In order to restore the backup all you have to do is to run LOAD DATA INFILE query.
7. Backup Your Database Into an XML File By Using PHP
It will display a PHP snippet that outputs your database as XML. XML is not one of the easiest format to restore a table but it is definitely easier to read.
8. Backup MySQL Database Through SSH
SSH可用于使用大型MySQL數據。You will have to enable shell access in your cPanel or Plesk control panel and utilize a tool like PuTTY to log into your server through SSH.
9. How to Backup MySQL Database Automatically (For Linux Users)
在這個教程中你將學習如何利用Linux系統cron自動備份數據。“cron”是一種在Unix/Linux系統中使用基于時間的計劃任務安排工具。
10. Ubuntu Linux Backup MySQL Server Shell Script
如何在基于Ubuntu Linux的VPS服務器上，將所有的MySQL數據庫服務器備份到Ftp服務器上。