Knowledgebase: Hosting
Database Backup
Posted by Clarke M on 03 April 2006 07:57 PM
If you go to so much effort to collect and store data Then you should backup your database.

First do it right now.
Then make a plan for regular backups and devise a naming scheme for the files or folders.
eg:
my_db_jan_2004

Microsoft Access:
Copy your '.mdb' file from your website and store it in some other location.

MySQL:
I recommend using PhpMyAdmin. http://www.phpmyadmin.net/home_page/
For info on installing this see http://forums.kingston.net/viewtopic.php?t=100024
Open your PhpMyAdmin page
Select your database (if you have more than one)
Click 'Export' . If this option is not visible select a table first.

Under Export, Click 'Select All' if you wish to backup all tables. The format defaults to 'SQL' but you can choose another format if required.

Ensure that both 'Structure' and 'Data' are selected.
Then select 'Save as file'
Next, Choose a file name.
If diskspace or connection speed are issues you can elect to ZIP the file.
Now click 'Go' and the file download will start,
Save the file.
What can I do with this file?
You can restore or duplicate your database as required.
If you saved the file in 'SQL' format
Open your PhpMyAdmin page
Select your database.
Click 'SQL'

Click Browse. Locate your backup file and press 'Go' .
(546 vote(s))
This article was helpful
This article was not helpful

Comments (0)
Help Desk Software by Kayako Fusion