Advanced Site Transferswith Akeeba Backup

Πέμπτη, 31 Μαρτίου 2011

Hi, I’m Nicholas Dionysopoulosand I bet you can’t pronounce my last name

Πέμπτη, 31 Μαρτίου 2011

Framing the issue

Πέμπτη, 31 Μαρτίου 2011

Site transfers are easy, but…

Transferring a site

replacesan existing one

Πέμπτη, 31 Μαρτίου 2011

Why is that a problem?

Live site and dev site start as identical twins

You redesign the dev site = changes

The live site is ever changing = even more changes

The two sites have now floated too far apart

How do you combine two sites into one site without data loss?

Πέμπτη, 31 Μαρτίου 2011

Ever changing live sites?!

New or updated users

Forum posts

Comments

Sales

Any other kind of user submitted information

Πέμπτη, 31 Μαρτίου 2011

To the rescue!

Πέμπτη, 31 Μαρτίου 2011

A man with a plan

1.Identify changing data

2.Exclude them from the dev site backup

3.Merge the two sites

Πέμπτη, 31 Μαρτίου 2011

Excluding users’ tables

• Joomla! 1.5

➡ #__users➡ #__core_acl_aro➡ #__core_acl_groups_

aro_map

• Joomla! 1.6

➡ #__users➡ #__user_usergroup_

map➡ #__user_profiles

Don’t forget user mapping tablesfrom other components!

(forum, K2, download system, ...)

Πέμπτη, 31 Μαρτίου 2011

Excluding tables

• Not an exact science. Be patient and careful!

• Tables are usually named like jos_component_table, e.g. jos_k2_items

• Exclude tables which have changed on the live site

• If unsure, ask the component’s author

• You can’t merge two versions of the same table

• Use Database Table Exclusion to exclude them

Πέμπτη, 31 Μαρτίου 2011

Database table exclusionExample: Excluding K2’s items from the backup

Πέμπτη, 31 Μαρτίου 2011

Excluding files and folders

• No need to exclude extensions

• Good candidates for consideration:

✓ Avatars (JomSocial, Community Builder)

✓ E-shop product images (VirtueMart, Tienda, redShop)

✓ Forum attachments (NinjaBoard, Kunena, Agora)

✓ Downloads (ARS, DOCman, RokDownloads)

• If unsure, ask the component’s developer

• Use “Files and Directories Exclusion” to exclude them

Πέμπτη, 31 Μαρτίου 2011

Things to never do

• Skip the contents of the table instead of excluding it

• Use the “Extensions Filter” feature

• Have users add/modify articles on the live site while you modify the same or different articles on the dev site.

• Take separate database and file backups

Πέμπτη, 31 Μαρτίου 2011

Test merge

• Backup the live site and restore locally to a test site.

• Backup the dev site and restore on top of the test site.

• Check the new site

‣ Missing users

‣ Logging in as a user created just before the test merge

‣ Scrutinized review of your site’s features

‣ Also try creating users, posts, test sales, etc.

• Is everything working? If not, review your exclusions!

Πέμπτη, 31 Μαρτίου 2011

Live merge

• Backup the live site and keep a local copy!

• Put your live and dev sites off-line.

• Backup the dev site.

• Uninstall extensions from the live site that were uninstalled on the dev site.

• Restore the dev site backup on top of the live site.

• Check that everything works. If not, restore from backup.

• Put the live site on-line.

Πέμπτη, 31 Μαρτίου 2011

Questions?

Πέμπτη, 31 Μαρτίου 2011

That’s all folks!Download this presentation & accompanying PDF:http://akeeba.info/site-transfers

Πέμπτη, 31 Μαρτίου 2011