One of the many great features of MySQL is the ability to back up a table. This can be done for a number of reasons, including creating a backup in case of data loss, or for disaster recovery purposes.
To back up a table in MySQL, use the mysqldump utility. This can be done from the command line, or from within a script. The following example shows how to back up a table using the command line:
mysqldump -u username …
