Installation Manual

Installing the Default Sample Data
The sample default data is a collection of Sections, Categories, Articles, Web Links, News Feeds, and
various other examples of content that have been written simply to demonstrate some of the functionality of
Joomla! (much of the content is also quite informative and useful). The data is contained in an SQL file within
the core installation.
By default the Install Default Sample Data radio button is selected, but in order to complete the installation of
the Sample Data you must also click the adjacent Install Sample Data button. Provided all goes well you will
notice that this button transforms into a confirmatory message box stating that the Sample Data Installed
Successfully; you are then ready to complete this section by clicking Next.
Warning! It is not possible to simply do an SQL back-up of a 1.0.x version Web site and upload this to a 1.5
version installation as a result of the significant changes that have taken place with regard to the framework
of Joomla!.
Installing a Compatible SQL Script File
There may be situations where for example you have your own localised – in language terms – version of the
Sample Data, or a back-up of data from an existing Joomla! 1.5 Web site that you wish to restore/install into
the new Web site you are creating. You should complete the Old Table Prefix, and Migration Script items
below.
Installing a Migration SQL Script File from an earlier Joomla! version 1.0.x installation
There is a separate and detailed guide on migrating content from earlier Joomla! installations available from
the Joomla! Help Site regarding the Migrator Component.
If you are migrating or restoring data select the Load Migration Script radio button. You will notice that this
then enables the additional fields for Old Table Prefix, Old Site Encoding, and Migration Script.
Old Table Prefix:
This is the prefix used in the database from which the data is being transferred. For example, it may be
mos_ from a default Joomla! 1.0 installation or, if uploading from a core SQL file #__.
Old Site Encoding:
Refers to the Language Encoding used by the donor MySQL database also known as the Collation. Joomla!
1.5 must be encoded with the UTF-8 language. The Old Site Encoding details can be obtained by referring
(in PHPMyAdmin) to the Databases tab of the main page.
Migration Script:
Browse to the Migration Script SQL data file you want to upload from a Joomla! 1.0.x installation that has
been created using the Migrator Component.
Warning: The Migrator Component clearly cannot compensate (add) data to any new fields that have been
added by the Joomla! 1.5 development (it's good but not magical) therefore it is recommended that you
check all migrated data and complete any missing fields that require such action. The most prevalent of
these will be the Alias field of Sections, Categories, and Articles.
I have already uploaded...:
Select this check box if you find that the SQL file is too big to handle (memory and time limit errors) and
upload the file in the joomla_root/installation/sql/migration/ called migrate.sql (no
compression allowed).
This script is a Joomla! 1.0 migration script:
Check this box if (and only if) you are migrating data from an earlier Joomla! 1.0 Web installation, having
used the com_migrator Component. This will enable the built in automatic process to complete the
transformation of the data to a compatible format with the Joomla! 1.5 framework.
Once you have completed the details on this page select the Next button to proceed to the final step.
The Joomla! User Documentation Team 23 The Joomla! v1.5 Installation Manual