Since you are likely not wanting to really use 1.9 (which is really old by now), you are likely wanting to upgrade your data from 1.8.x to 1.9.x so you then upgrading to Tiki 9.x or later. To do so, you can manually run db/tiki_1.8to1.9.sql which is part of your Tiki download and then, use the Tiki installer (at tiki-install.php) to do the rest.

Upgrade 1.8 to 1.9

Upgrading from Version 1.8.x

  1. Clear templates and module cache in Admin -> System Admin
  2. Backup your existing database (use the command mysqldump or use phpMyAdmin)
  3. Download the 1.9.x package from our SourceForge Project Area
  4. Uncompress the 1.9.x package
  5. Upgrade your database (see below)
  6. Copy over the contents of the 1.9.x tiki dir to your exisiting tiki web root (eg /var/www/html/tiki)
    • Linux users can use: cp -R tiki/* /var/www/html/tiki/
    • Windows users equiv: xcopy tiki\* c:\inetpub\wwwroot\tiki\ /e
  7. Run again to verify the correct permissions are set (read Installation again if you don't remember how to use this script)
  8. Remove the contents of templates_c, the temp and modules/cache directories

You should now be running a 1.9.x site.


  • Do not delete the 1.8.x directory and uncompress tiki 1.9.x over. You may loose images uploaded in wiki or custom avatars or some other content. If you want to have a clean install (no old files) then make a backup of the 1.8.x installation directory before you do that.
  • You can use the secdb database files to check your installation directory for old/modified files. See Security Admin

Upgrading the database

Upgrade scripts are located in the "db" subdirectory and can run by either the phpMyAdmin or mysql command. Here is how to run it with the mysql command:

mysql -f -u dbuser -p tikidb < tiki_1.8to1.9.sql

where "dbuser" is the name of a mysql user with sufficient privs in the tiki db to modify that table structures and data rows (probably root), and "tikidb" is the name of your tiki database. The -p is only needed if you have a password on the database (which is highly recommended). The -f is required to force all the updates to occur.

For hosted site with CPanel access, you can use phpMyAdmin's import function to execute the script. Unfortunately, the import function will stop at the first error encountered. You will have to removed every SQL statements that have been executed and run it again until you reach the end of the script.

(Note: If you are upgrading to 1.9.y from a previous 1.9.x, you will also need to run the 1.9.xto1.9.y.sql script)

You can safely ignore any errors, but if the script aborts (as it would without the -f), then your database will be missing part of the update.

Upgrading your css file

The new classes that have been added from 1.8 to 1.9 are listed in the file styles/transitions/1.8to1.10.css


Please also see the following links if you want to upgrade to the latest stable version of Tikiwiki from either 1.8.x or 1.9.x

Other warnings:

  • 1.9.0 does contain security issues, you are advised to upgrade straight to release, at least, or to the latest stable version (without installing 1.9.0)
  • As with any new stable version, you can expect minor bugs with 1.9.x branch. Please report them on
    Any sane admin with a valuable Tiki will want to backup its database before the upgrade, using MySQL (for example mysqldump or phpMyAdmin).
    plus backup daily in case of problems.
  • Upgrading will require a number of files. Leaving tiki-install.php or sql files after upgrading is a bad idea that could potentially help people to screw up your Tiki.

Upgrading from before 1.8

  • Please see the UpgradeTo18 page, and follow the steps carefully

Related information