One of the most important tasks for a webmaster is to keep a current backup of your database or databases. How the database is used will determine the frequency of your backups. If the database is for a large website or in-house application, you probably will use a program to backup your database automatically. But if you are a small website or the database is low priority, you might just perform the backup manually. One easy way to manually backup your database is to use the backup feature of a database management application such as the open source, freeware program called phpMyAdmin. The Export feature of this program will create a backup file containing both the structure of your database and the data stored there. The instructions below are for the phpMyAdmin version 2.8.1. (If you are using a different version, the workspace may vary slightly.)
|