Actions

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

From Joomla! Documentation

m (Database Backup Part 1 of 2)
Line 1: Line 1:
 +
{{merge|What are the best practices for site backups?}}
 +
 
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.
 
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.
  
Line 5: Line 7:
 
== Summary ==
 
== Summary ==
  
There are two parts to a complete back up of your Joomla site.
+
There are two parts to a complete back up of your Joomla site
 
   
 
   
 
a) The database information, most often found in your mysql database
 
a) The database information, most often found in your mysql database
Line 13: Line 15:
 
== Database Backup  Part 1 of 2 ==
 
== 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.   
+
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';" or "public $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.   
 
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.   
Line 36: Line 38:
 
'''
 
'''
  
== More Backup Documentation ==
+
== More Backup Documentation ==
 
+
Some backup help can be found on the documentation for beginners. [http://docs.joomla.org/Beginners] which includes a rough video [http://video.google.com/videoplay?docid=2742157386318372444]   
+
 
+
Most managers of a Joomla website have access to their SQL data using the GUI interface called PhpMyAdmin.  The URL below is a helpful video with steps to backup a database, but they are somewhat incomplete.  It's a visual preview of using PhpMyAdmin (common on most web hosts): http://www.phpmyadmin.net/documentation/#faq6_4
+
  
 +
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.
 
   
 
   
There are several more automated backup extensions for Joomla 1.5 [http://extensions.joomla.org/extensions/access-a-security/site-security/backup/1606 Akeeba Backup (formerly JoomlaPack)] for a full backup of your site or SQL Dumper that can be used for both creating and restoring Joomla databases, Although if for some reason Joomla becomes impossible to log into, the backup will need to be restored through PhpMyAdmin or another method. both these extensions and more are available at http://extensions.joomla.org/
+
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.
 
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==
 
==Special Notes==
=== Tools ===
+
=== Automated Backup Tools ===
  
 
==== Akeeba ====
 
==== Akeeba ====
Line 61: Line 59:
 
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.
 
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, it can be download from [http://extensions.joomla.org/extensions/access-a-security/site-security/backup]
+
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 23:51, 3 October 2013