|CyberSite.net Knowledge Base|
|How to backup your MySQL database with phpMyAdmin.
Backing Up Your MySQL Database
1. To manage your MySQL database, you'll first need to login to the online manager (phpMyAdmin).
2. After you are logged into the online manager, click on a database or table in the left frame as shown in this example:
The properties for this database or table will be displayed.
3. Then on the menu, click Export:
4. To save the backup, you will need to check the box marked Save as file, so that phpMyAdmin will prompt you to download the resulting backup file. You can also change the name of the backup file and the compression--though the defaults are both fine if you would rather not change anything. If you do choose to use compression this will allow you to have a smaller backup file on your desktop if you are planning to keep it as a personal archive. The recommended setting is "gzipped":
The Finish Line
|Copyright 2011 CyberSite.net, a subsidiary of Group One Communications, Inc., All rights reserved worldwide.