If you have installed a blog, forum or content management system (CMS) such as Joomla on your server you will have installed a mySQL database. One day without warning your server may crash and you’ll lose all your files. This is why it is important to create a backup of database and files.
If your web site only contains html files it’s very easy to restore them because they are stored on your computer. You simply need to upload them to the server.
Methods of backing up your SQL database
1. Web hosting providers - Most web hosting providers backup all files on their server. My server gets backed up daily, weekly and monthly. Check with your web host to see how often they do backups.
2. Backup software for your forum, blog or cms
Most CMS web sites that use databases have their own backup system software. e.g.,
a) WordPress has a plugin (http://www.ilfilosofo.com/blog/wp-db-backup/) where you can select how you want the backup to be delivered:
* Save to server : this will create a file in /wp-content/backup-*/ for you to retrieve later
* Download to your computer : this will send the backup file to your browser to be downloaded
* Email : this will email the backup file to the address you specify
b) Joomla has an extension called JoomlaPack (http://www.joomlapack.net/). It’s a component that creates a backup of your whole site (files and database) in the form of a single archive. In order to help you restore this, it also adds an installer. All you have to do to restore your backup is follow the regular Joomla! installation procedure: unpack the archive, upload files, point your browser to the installation script, follow the installation screens and you’re ready.
c) Simple Machines Forum (SMF) allows you to create a backup of the forum database within the admin panel.
3. Cpanel backup
Use the MySQL Database Wizard to download a zipped copy of your entire site or parts of it onto your computer.
The following are backed up and included in a zip file:
* Home Directory
* MySQL Databases
* Email forwarders configuration
* Email filters configuration
To access the MySQL Database Wizard login to:
www.domain.com/cpanel
files
backup wizard
save the files to your local drive
4. phpMyAdmin
Have you ever lost all your computer files because you didn’t back them up?
It’s a sickening feeling when you can’t restore thousands of files collected over several years of work. The same thing can happen to your forum, blog or CMS web site that uses a mySQL database to store information. One of the easiest and most full proof backup methods is to use phpMyAdmin.
How to use phpMyAdmin
Go to cPanel->mySQL databases->phpMyAdmin and choose your database.
Click on the Export link.
Choose Select All to select all the tables.
Select “SQL”->for output format.
Check “save as file”
Select gzipped and hit Go to download the backup file.
Save it to a folder labeled “backupFeb08″ so you know when you created the last backup.
Create a backup the first of every month.
How to restore a backup of a mySQL database
Click the SQL tab
On the “SQL” page, unclick “show this query here again”
Browse to the backup of the database on your computer
Click Go.
Nema komentara:
Objavi komentar