Fullscreen
3d browser Print

Previous page Parent page Next page TOC
Structure   (3.16)   Documentation  »  Installation  »  Upgrade

Upgrade your Tiki site

Upgrading Tiki is easy when you have mastered its installation.

Table of contents



1. Create a Backup


See: Backup

Note: To protect your content, you must backup your database and customized theme style files. Before you upgrade, make sure you have a backup of your sql database and your customized .css and .tpl. files (if any)



2. Choose an upgrade path.

Like most software, you should not attempt to upgrade a very old installation to a very new one. Some upgrades include changes to the database, some do not. If you skip over an upgrade that contains a database change, this change may not be included in later versions of the database upgrade scripts.

To 3.latest



3. General Notes:

On the tiki-install.php page of this "new" site connect to the same database as your current site and follow the instructions to upgrade your site.

At the end proceed as usual to the wiki site while disabling the tiki-install.php script.

Check your new web site contains everything from the old web site. Things that you may need to copy from your old site to your new site:
  • img/wiki_up folder content (wiki images)
  • some customised tpl
  • some customised styles (css)
  • some customised wiki-plugins and pages
  • the file gallery directory if using the disk to save the files
  • the image gallery directory if using the disk to save the images

When you are happy with the result delete the directory structure of the old site and move the directory of the new site in place. In fact on GNU/Linux you can use a symlink instead, making upgrade easy.
ln -s tikiwiki-3.0 tiki


For more information, please see: Upgrade 2.x to 3.x

In order to upgrade MultiTikis in subdirectories, you can follow also the instructions at the Manual Installation page.




4 Upgrade your Theme

The display of the theme style in Tiki 3 has changed from previous versions of Tiki. So you'd better start playing with one on the bundled themes in your tiki3 installation, and fine tune your css to meet your needs (and/or past theme style design), because you might not need to adapt your tpl files.

And in case you need to adapt them, you might find it easier to update the new tpl files with the modifications you need, than to start from your old tpl files and attempt to apply all the changes in display that were introduced in Tiki 3.

For more information, please see: Upgrade 2.x to 3.x



For a more detailed description, read Styles and Themes

Alternative: Upgrading your database through shell

Upgrading your database manually through shell (faster than phpmyadmin)

In case anything fails with the automatic upgrade through tiki-install.php, you can manually upgrade the database. We assume that you have already created a database Backup as suggested previously, but just in case, we will also show the steps to produce that backup. After that we will create a new database, populate it with the backup copy, and upgrade it to meet Tiki 3.0 latest schema.

Some devs reported that they use this script (use at your own risk):
sh doc/devtools/sqlupgrade.sh


However, if your are unsure, you can do things manually. It may work better but generally requires access to the command line / shell level of your server. If you are a cpanel user, see modified instructions below.

This is the assumed configuration for this example:

  • Tiki database username: tiki
  • Tiki database password: secret
  • Admin database username: root
  • Admin database password: topsecret
  • SQL database name (current/old version): tiki20
  • SQL database name (new/upgrading-to version): tiki30
  • Directory where Tiki is currently installed: /home/youruser/public_html/tiki

Note: If you forgot the above information, check your db/local.php file for most of the values. If you do not have admin access to your MySQL database, you will need to use MySQL Databases or similar to create and drop databases.


  1. % cd /home/youruser/public_html/tiki/db
    This changes the current working directory to the directory where the sql scripts from tiki are stored.

  2. % mysqldump -u tiki -p secret tiki20 > tiki20-backup.sql
    This exports your old 2.0 database to a file, so you can import it into another database.

  3. % mysqladmin -u root -p topsecret create tiki30
    This creates the new database to hold your 3.0 Tiki data. We use database names like tiki20 and tiki30 instead of just calling them all tiki because it makes it easy to run multiple versions on the same machine.

  4. % mysql -u tiki -p secret tiki30 < tiki20-backup.sql
    This copies all your old 2.0 data into the new 3.0 database. You can not just use this new database, though, because Tiki 3.0 is expecting the database in an updated format (new tables, new columns, etc). That's what the upgrade script does.

  5. % mysql -u tiki -p secret -f tiki30 < tiki_2.0to3.0.sql
    This starts the conversion from the 2.0-format data to 3.0-format data in your new database. Remember that this upgrade SQL script is in the db/ subdirectory, where all the other former upgrade scripts are. NOTE: However, there is a second step to follow, since Tiki 3.0 introduced a new way of handling automatic updates of the database, and each change from each developer has its own sql script in another folder, sorted by date.. So that you are not finished yet, but instead, you need to proceed to the following step.

  6. The second part of the upgrade scripts
    You can manually run all the sql scripts that you will find under the folder:
    installer/schema/

    If you are in GNU/Linux, and while in the db/ folder, you can do that in two steps through a terminal:
    1. Join all sql files together:
      % cat ../installer/schema/*.sql ../installer/schema/all.sql


    2. Run the sql upgrde script as usual
      % mysql -u __tiki__ -p __secret__ -f __tiki30__ < all.sql

Note: The collected SQL scripts have generally not been written to allow execution more than once. And any error will stop a script at that point. So if you create an all.sql file, you may have to comment out up until the error and restart. Consider using a looping mechanism (e.g. foreach) with a comment printed as each file is executed to more robustly go through these scripts. If you are doing this manual process, it is likely because the automatic way did not work and so you are likely to experience problems.


At the end, you should manually create a file called "lock" inside the db/ folder where your local.php file is stored, in order to secure your installation.





Related pages



Contributors to this page: RandyH92 points  , meta4r41 points  , mizraith252 points  , SEWilco321 points  , xavidp659 points  , xavi8602 points  , marclaporte2952 points  , mlpvolt1470 points  , sylvie1679 points  and Franck19 points  .
Page last modified on Tuesday 30 June, 2009 21:06:30 UTC by RandyH92 points .

Documentation Menu

To register

To have an account at this site, please register at Tikiwiki.org (external link), and then use that user name and password to log in here.

This site gets user information from Tikiwiki.org with the InterTiki feature.

Folksonomy

Anti-Bot verification code: Random Image
Enter the code you see above:

Compare

Wiki Feature Comparison

Search by Page Name

Exact match

Menu

Keywords

The following is a list of keywords that should serve as hubs for navigation within the Tiki documentation and should correspond to development keywords (bug reports and feature requests):

Accessibility (WAI – 508)
Action log 2.x
Alert 3.x
Articles & Submissions
Backlinks
Backup
Banner
Blog
Bookmark
Browser Compatibility
Cache
Calendar
Category
Charts
Chat
Comments
Communication Center
Compression (gzip)
Contacts Address book
Contact us
Content template
Contribution 2.x
Cookie
Copyright
Custom Home (and Group Home Page)
Database independence
Date and Time
Debugger Console
Directory (of hyperlinks)
Documentation link from Tiki to doc.tikiwiki.org (Help System)
DogFood
Drawing
Dynamic Content
Dynamic Variable
External Authentication
FAQ
Featured links
File Gallery
Forum
Friendship Network (Community)
Game
Gmap Google maps
Group
Hotword
HTML Page
i18n (Multilingual, l10n, Babelfish)
Image Gallery
Import-Export
Install
Integrator
Interaction
Inter-User Messages
InterTiki
JS Calendar
Karma
Live Support
Login
Look and Feel
Lost edit protection
Mail-in
Map with Mapserver
Menu
Meta Tags
Mobile Tiki and Voice Tiki
Mods
Module
Mootools 2.x
Multimedia 2.x
MultiTiki
MyTiki
Newsletter
Newsreader
Notepad
PDF
Performance Speed / Load
Permission
Platform independence (Linux-Apache, Windows/IIS, Mac, BSD)
Poll
Profile Manager
Quicktags
Quiz
Rating
RSS
Score
Search engine optimization
Search
Security
Semantic links 3.x
Shadowbox
Shoutbox
Slideshow
Smarty Template
Smiley
Spam protection (Anti-bot CATPCHA)
Spellcheck
Spreadsheet
Stats
Survey
System log
Tags 2.x
Task
Tell a Friend + Social Bookmarking 2.x
TikiTests 2.x
Theme
Trackers
TRIM
User Administration including registration and banning
User Files
User Menu
Watch
WebHelp
Webmail
Webservices
Wiki 3D
Wiki History, page rename, etc
Wiki Page Staging and Approval 2.x
Wiki Plugins extends basic syntax
Wiki Syntax
Wiki structure (book and table of content)
Workflow (Galaxia Workflow engine)
WYSIWYCA
WYSIWYG 2.x
XMLRPC