Installationsanleitung

Erstellen der database

Tiki setzt eine ))MySQL(( Datenbank vorraus.
Die zwei Schritte zum anlegen der tiki ))MySQL(( Datenbank sind:

• Erstellen der Datenbank
  

  mysqladmin -u root -p create '[DATABASE]'

• Anlegen des tiki users mit password und den erforderlichen Berechtigungen. Der user und der DATABASE name wird in den file .../db/local.php des tiki directory eingetragen.
  

  mysql -u root mysql -p
  grant SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER 
  on [DATABASE].* to [USER]@localhost identified by '[tiki PASSWORD]';

Installation der 5.x tiki Softare vom SVN repository

Folgende Schritte müssen durchgeführt werden um die letzte Version des Tiki 5.x vom SVN zu installieren

• Checkout des code.
  Checking out mittels SVN
  

  svn co https://tikiwiki.svn.sourceforge.net/svnroot/tikiwiki/branches/5.x

  
  Using the above command will checkout Tiki to a folder with the same name as the last part of the checkout command (in this case 5.x). If you wish to checkout to the current directory, just add "." to the end of the command line:
  Checking out to a Different Folder
  

  svn co https://tikiwiki.svn.sourceforge.net/svnroot/tikiwiki/branches/5.x [TARGET]

2. Update from SVN.
Updating with SVN is easy. Navigate to the directory that has your checkout, and type:

svn update



3. Update SVN to a specific revision.
To update your source to a specific revision, use:
Updating to a Revision

svn update -r REVISION



4. Fixing permissions.
After updating, you may wish to run sh setup.sh to change the updated file ownerships and permissions. To do so, use:
Fixing permissions

sh setup.sh

Exportieren von TikiWiki database tables

Achtung dies gilt nür für ein Transfer von einem bestehenden TikiWiki auf ein leeres TikiWiki

Export der Dateiarchive Table

USE DATABASE;
SELECT *    INTO OUTFILE '/tmp/tiki_files.csv'
    FIELDS
       TERMINATED BY ','
       OPTIONALLY ENCLOSED BY '"'
       LINES TERMINATED BY '\n'
    FROM tiki_files;
SELECT *    INTO OUTFILE '/tmp/tiki_file_galleries.csv'
    FIELDS
       TERMINATED BY ','
       OPTIONALLY ENCLOSED BY '"'
       LINES TERMINATED BY '\n'
    FROM tiki_file_galleries;

Import der Dateiarchive Table

USE DATABASE;
LOAD DATA INFILE '/tmp/tiki_files'
    INTO TABLE tiki_files
    FIELDS
       TERMINATED BY ','
       OPTIONALLY ENCLOSED BY '"';
LOAD DATA INFILE '/tmp/tiki_file_galleries.csv'
    INTO TABLE tiki_file_galleries
    FIELDS
       TERMINATED BY ','
       OPTIONALLY ENCLOSED BY '"';

CCF interne TikiWiki Database

Anlegen der internen CCF TikiWiki Databases

---