Actions

Difference between revisions of "Backup Basics for a Joomla! Web Site"

From Joomla! Documentation

m (More Backup Documentation: updating section)
(14 intermediate revisions by 5 users not shown)
Line 1: Line 1:
Backing up data is vital for businesses; lost information can cause a major crisis or worse, lead to business failure. Individuals who don't backup computer data run the same risk. While this may not cause financial ruin, it can certainly be frustrating and even heartbreaking. Computers aren't perfect. Servers malfunction or are open to vulnerabilities, files become corrupt due to script kiddies or malware bots, motherboards malfunction, CPUs call it quits taking our precious data with them. Data backup can mean the difference between a slight computer setback and living through your own electronic apocalypse.
+
{{merge|What are the best practices for site backups?}}
  
Backing up data is vital for businesses; lost information can cause a major crisis or worse, lead to business failure. Individuals who don't backup their Joomla site run the same risk. While this may not cause financial ruin, it can certainly be frustrating and even heartbreaking.  
+
Always keep a recent backup of your site. There is more to backup than accidentsAccidents do happen, but there are many other reasons it helps to have your backup files handy before the need arises.   The causes of data loss are many.  Joomla sites can be compromised by malicious attackers if the site administrator has not paid attention to security, or in rare cases when hackers bypass the best security.  Joomla is designed for teamwork, and even good editors can make an error to harm the site.    There are many reasons website administrators need to revert the site back to a previous working state.
   
+
Backing up your site involves the storing of files/folders and database information from your server in another location. In this way, if there is ever any loss of data on your server, you still have your data in backup in order to restore those files. In the world of computers, loss of data can be devastating, and while there are possibilities for recovery of data after a disaster it is far easier to restore your files/db from backup than having to restore manually your entire Joomla website. So make regular backups and store them on different media i.e. a flash disk (or 2 to make sure you still have one if your flash disk gives up on you!) or a commercial Cloud storage provider such as [http://aws.amazon.com/s3/ Amazon S3]
+
  
Check always that the backup you make is not corrupt and contains the actual data! You can create a copy of your site on a local installed server to test the backup and/or practice restoring your site.(see link below " Copying a Joomla website "
+
It helps to practice both backup and restore.  Nobody should wait for an emergency to test their skills and tools for dealing with an emergency.  Very often people create a backup of something that is empty or corrupted, and discover that none of their critical data was really backed up in the first place.  Nobody likes a ship that sinks with empty lifeboats, and it's also wise to practice getting people out of the lifeboats and into a new working system.  Having a backup is not just about accidents, because a person well versed in backup can help with safe development of new features.  Backup and restore help web managers create a staging website where new changes can be practiced without risking the production website.    The clone can be created on a local machine acting as a test server, or any other folder or web hosting account supporting the SQL and PHP versions used by the site you've backed up.  It's easy for anyone to mix up their live site and staging site, so change the color of your staging site template to remind developers that the staging site is not live to the public.  
  
 
== Summary ==
 
== Summary ==
  
To backup your webesite you will need to backup:
+
There are two parts to a complete back up of your Joomla site
 
   
 
   
a) Your Joomla database [and]
+
a) The database information, most often found in your mysql database
  
b) The files and folders of your website
+
b) The files and folders on your website, as hosted on most static html websites
  
== Manual System Backup ==
+
== Database Backup Part 1 of 2 ==
  
How to backup the database and site is well documented in [http://docs.joomla.org/Copying_a_Joomla_website[Copying a Joomla website]
+
One of the first steps to backup your Joomla site is to close the site to the public, backup the files, and then re-open the site. The steps from phpmyadmin.net omit this much needed operation.  Go to the backend of your Joomla control panel, under global configuration, under the site tab, set "site offline" = yes.  This will then change the look of your configuration.php file in the root of your Joomla website.    An administrator will need to use your hosting control panel to view that file or use FTP to download and view the file.  Inside configuration.php you can find the name of your database that will need backing up.  Look for the line with code resembling "var $db = 'x1234';"  Where x1234 is the name of your database. 
  
For the database back-up we use phpMyadmin and a good tutorial can be found at [http://joomlatutorials.com/joomla-tutorials/joomla-15x/joomla-15x-administration/backup-database.html Joomlatutorials]
+
Using the logon information for your server or hosting company open the PhpMyAdmin tool. Open the database and look for the table named "users" and then click the icon to "view" the data in that table.   You should see the names of staff who have accounts on your Joomla site.  This view provides you the confidence that you are about to backup the correct database. Click the export tab, then go.  Your browser will download your database into an SQL file.  Find where you browser put that file, then move the file to a much more secure drive or location. 
  
For backing up your files and folders you need to use an FTP-client such as the very popular [http://filezilla-project.org/ Filezilla] or any of the dozens described in this [http://en.wikipedia.org/wiki/Comparison_of_FTP_client_software wiki-entry] but check the [http://forum.joomla.org/index.php Joomla forum] what is widely used if your are not sure what ftp-client is suitable for you!
 
  
== Automated system backup ==
 
  
Several automated [http://extensions.joomla.org/extensions/access-a-security/backend-a-full-access-control backup extensions] for Joomla 1.5 are available and highly sophisticated is the free backup and restore extension [http://extensions.joomla.org/extensions/access-a-security/site-security/backup/1606 Akeebabackup] which offers in its commercial version several interesting and helpful features as fully automated backups via cronjobs.
+
Server SQL databases can be backed up without PhpMyAdmin and instead using the SQL command line. If you know how to do that, you're most likely not in need of this documentation.
  
If you use cPanel as Control Panel and your host has enabled daily/weekly/monthly backups you will be able to download these backups from your CTRL-panel, tab "backups". A full backup includes all of the files in your home directory, your MySQL databases, and your email forwarders and filters. You can back up your account and move your account to another cPanel server.
+
It is recommended to back up the database at least twice per week or even everyday (and more) if you have an active site.
  
== More Backup and Restore Documentation ==
+
== File System Backup Part 2 of 2 ==
  
Frequent backups are the best way to make sure you can recover if your site has a problem. This video entitled [http://video.google.com/videoplay?docid=2742157386318372444 How to backup and restore a Joomla! database using phpMyAdmin] by kristofdb explains also the steps.   
+
Continue with your site offline, see above. Your joomla folder and files can be backed up by downloading them with an FTP utility or using the file manager of your webhosting company.  Both of these file options work, neither is better.   
  
More info on phpMyAdmin can be found at the homepage of [http://www.phpmyadmin.net/home_page/index.php PhpMyAdmin]  
+
FTP tools move thousands of Joomla files and use more time.  The FTP process can be slow and interrupted.  Many Joomla sites are hosted by providers like godaddy or hostgator who provide a control panel for taking thousands of files in one folder and then creating a zip file very quickly.  This means your site is offline for a shorter amount of time, and you have only one zip file.  Go to your hosting control panel and look for their file manager icon. 
 +
 
 +
If you use your hosting file manager, practice using that interface to select your server folder and creating a zip file.  Download the zip file locally and then expand it locally to to see what files are inside that zip file.  This option also let's you expand the same zip file for restoration to a staging site.
 +
 
 +
Backing up the Joomla files with FTP is no different than backing up a static HTML website. Download all the files and folders that exist in the main Joomla directory.  The downloaded locaiton is a folder on your local computer. Be sure that the file and directory structure remains the same as it is in the live site.  When you restore the files, you will use the FTP utility to upload the files to a new server.
 +
 
 +
'''As soon as you've downloaded your files via zip or FTP, change your site to be online.
 +
'''
 +
 
 +
== More Backup Documentation == 
 +
 
 +
Most administrators of a Joomla website have access to their MySQL data using the GUI interface called PhpMyAdmin, see [https://phpmyadmin.readthedocs.org/en/latest/faq.html#how-can-i-backup-my-database-or-table How can I backup my database or table?] for more information.
 
   
 
   
Never store the backup on your own server (!) Also do not backup your site(s) on a mirror disk (VPS/Dedi server) on the same server ''only'' since the entire server or datacentre might burn out!
+
There are several automated backup extensions for Joomla! located in the [http://extensions.joomla.org Joomla! Extensions Directory]. Here is a link for [http://extensions.joomla.org/extensions/access-a-security/site-security/backup Joomla! Backup Extensions].
 +
 
 +
When servers are hosted in the same building as the staff, the web administrators should make extra care to store the backup copies of the database/files in a different building.  Fire, theft, water or other damage often wipes out the live website AND backups.  On a regular basis the web administrators should burn both the database and files to CD or save to an external hard drive off site.
 +
 
 +
==Special Notes==
 +
=== Automated Backup Tools ===
 +
 
 +
==== Akeeba ====
 +
 
 +
* Akeeba Backup produces a .jpa file that you should download to a safe location that's not on your webhost or webserver.
 +
 
 +
* The .jpa file contains all the folders/files and database files.
 +
 
 +
* The .jpa file also contains an installer
 +
 
 +
These paragraphs are about backup, but it's worth a quick note that the Akeeba restore process is a fast guided process similar to a setup wizard.    Place 2 files on a new webhost.  a) your JPA file and b) Kickstart.php (from Akeeba) You then use a browser to launch the restore process and unpack the .jpa file.  Please read the Akeeba restore documentation.
 +
 
 +
Akeeba and other backup extensions can be download from [http://extensions.joomla.org/extensions/access-a-security/site-security/backup]
  
  
 
[[Category:Tutorials]][[Category:Security]]
 
[[Category:Tutorials]][[Category:Security]]

Revision as of 09:42, 8 May 2013

Merge-icon.png
Merge Notice

It has been suggested that this article or section be merged with What are the best practices for site backups?. (Discuss). Proposed since 14 months ago.


Always keep a recent backup of your site. There is more to backup than accidents. Accidents do happen, but there are many other reasons it helps to have your backup files handy before the need arises. The causes of data loss are many. Joomla sites can be compromised by malicious attackers if the site administrator has not paid attention to security, or in rare cases when hackers bypass the best security. Joomla is designed for teamwork, and even good editors can make an error to harm the site. There are many reasons website administrators need to revert the site back to a previous working state.

It helps to practice both backup and restore. Nobody should wait for an emergency to test their skills and tools for dealing with an emergency. Very often people create a backup of something that is empty or corrupted, and discover that none of their critical data was really backed up in the first place. Nobody likes a ship that sinks with empty lifeboats, and it's also wise to practice getting people out of the lifeboats and into a new working system. Having a backup is not just about accidents, because a person well versed in backup can help with safe development of new features. Backup and restore help web managers create a staging website where new changes can be practiced without risking the production website. The clone can be created on a local machine acting as a test server, or any other folder or web hosting account supporting the SQL and PHP versions used by the site you've backed up. It's easy for anyone to mix up their live site and staging site, so change the color of your staging site template to remind developers that the staging site is not live to the public.

Contents

Summary

There are two parts to a complete back up of your Joomla site

a) The database information, most often found in your mysql database

b) The files and folders on your website, as hosted on most static html websites

Database Backup Part 1 of 2

One of the first steps to backup your Joomla site is to close the site to the public, backup the files, and then re-open the site. The steps from phpmyadmin.net omit this much needed operation. Go to the backend of your Joomla control panel, under global configuration, under the site tab, set "site offline" = yes. This will then change the look of your configuration.php file in the root of your Joomla website. An administrator will need to use your hosting control panel to view that file or use FTP to download and view the file. Inside configuration.php you can find the name of your database that will need backing up. Look for the line with code resembling "var $db = 'x1234';" Where x1234 is the name of your database.

Using the logon information for your server or hosting company open the PhpMyAdmin tool. Open the database and look for the table named "users" and then click the icon to "view" the data in that table. You should see the names of staff who have accounts on your Joomla site. This view provides you the confidence that you are about to backup the correct database. Click the export tab, then go. Your browser will download your database into an SQL file. Find where you browser put that file, then move the file to a much more secure drive or location.


Server SQL databases can be backed up without PhpMyAdmin and instead using the SQL command line. If you know how to do that, you're most likely not in need of this documentation.

It is recommended to back up the database at least twice per week or even everyday (and more) if you have an active site.

File System Backup Part 2 of 2

Continue with your site offline, see above. Your joomla folder and files can be backed up by downloading them with an FTP utility or using the file manager of your webhosting company. Both of these file options work, neither is better.

FTP tools move thousands of Joomla files and use more time. The FTP process can be slow and interrupted. Many Joomla sites are hosted by providers like godaddy or hostgator who provide a control panel for taking thousands of files in one folder and then creating a zip file very quickly. This means your site is offline for a shorter amount of time, and you have only one zip file. Go to your hosting control panel and look for their file manager icon.

If you use your hosting file manager, practice using that interface to select your server folder and creating a zip file. Download the zip file locally and then expand it locally to to see what files are inside that zip file. This option also let's you expand the same zip file for restoration to a staging site.

Backing up the Joomla files with FTP is no different than backing up a static HTML website. Download all the files and folders that exist in the main Joomla directory. The downloaded locaiton is a folder on your local computer. Be sure that the file and directory structure remains the same as it is in the live site. When you restore the files, you will use the FTP utility to upload the files to a new server.

As soon as you've downloaded your files via zip or FTP, change your site to be online.

More Backup Documentation

Most administrators of a Joomla website have access to their MySQL data using the GUI interface called PhpMyAdmin, see How can I backup my database or table? for more information.

There are several automated backup extensions for Joomla! located in the Joomla! Extensions Directory. Here is a link for Joomla! Backup Extensions.

When servers are hosted in the same building as the staff, the web administrators should make extra care to store the backup copies of the database/files in a different building. Fire, theft, water or other damage often wipes out the live website AND backups. On a regular basis the web administrators should burn both the database and files to CD or save to an external hard drive off site.

Special Notes

Automated Backup Tools

Akeeba

  • Akeeba Backup produces a .jpa file that you should download to a safe location that's not on your webhost or webserver.
  • The .jpa file contains all the folders/files and database files.
  • The .jpa file also contains an installer

These paragraphs are about backup, but it's worth a quick note that the Akeeba restore process is a fast guided process similar to a setup wizard. Place 2 files on a new webhost. a) your JPA file and b) Kickstart.php (from Akeeba) You then use a browser to launch the restore process and unpack the .jpa file. Please read the Akeeba restore documentation.

Akeeba and other backup extensions can be download from [1]