Loading...
 

How to convert a Tiki database from 1.7.x to 1.8.x

1-Get these three files

tiki_1.7to1.8.sql
structure_fix_1.7to1.8.sql
comments_fix_1.7to1.8.sql

2- Backup your existing 1.7.x database (use the command mysqldump or use phpMyAdmin)


3- Run the upgrade scripts on your backup database

3a via phpmyadmin


Scripts needed to upgrade from 1.7.x to 1.8

  1. tiki_1.7to1.8.sql - this is the main upgrade script, it can be re-run as often as needed.
    • Note: errors relating to "duplicate entry" are normal and can be safely ignored
  2. comments_fix_1.7to1.8.sql - only run this once on a 1.7 database, then never again
  3. structure_fix_1.7to1.8.sql - only run this once on a 1.7 database, then never again
  4. tiki_1.7to1.8.sql - rerun to fix forums (can be run multiple times)

3b via shell (SSH)

Step by step:

  1. mysql -f -u dbuser -p tikidb < tiki_1.7to1.8.sql
  2. mysql -f -u dbuser -p tikidb < comments_fix_1.7to1.8.sql
  3. mysql -f -u dbuser -p tikidb < structure_fix_1.7to1.8.sql
  4. mysql -f -u dbuser -p tikidb < tiki_1.7to1.8.sql (re-run again to fix Forums)



Congratulations!. You now have a Tiki 1.8.x format database.

You can now use the regular Upgrade instructions to take you to the latest version.

List Slides