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:



This interface will generate a backup file that can be used to recreate your database or table (it's actually just a file containing standard SQL statements).

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":



Finish by pressing the Go button; this may take a few moments to complete. You will then be prompted to save the file to your desktop.

The Finish Line
Congratulations! You have just created a backup of your MySQL database!
If you experience a problem or you have further questions or concerns, please do not hesitate to contact our technical support 24x7 via phone, chat or by submitting a ticket through your control panel.

BACK TO KNOWLEDGE BASE TABLE OF CONTENT


*CyberSite.net takes no responsibility whatsoever for any files, code, content, database back-ups that are not made and/or are not made/done correctly. The information included on this knowledgebase page is usual and customary DB back-up procedures, but may not be complete. It is the client's responsibility to ensure that their site material is correctly backed-up. If a client prefers to make other arrangements or methods for backing up site material, it is at their sole discretion. CyberSite.net always recommends that client back-up their entire site on a regular schedule.

HOME | MARKETING | CREATIVE | DEVELOPMENT | MANAGEMENT | PORTFOLIO | PRODUCTS | HOSTING | CLIENT SERVICES | ABOUT CSN | SUPPORT | KNOWLEDGE | LEGAL & PRIVACY | SITE MAP

Copyright 2011 CyberSite.net, a subsidiary of Group One Communications, Inc., All rights reserved worldwide.
Please review our Terms, Conditions, Policies, Procedures, Terms of Use and Service.