[Summary view] [Print] [Text view]

   1  FIXME: The flatfile backend has not yet been ported to the new database
   2  scheme.  For now, it is broken.
   3  
   4  Note: mSQL will not be supported in the 1.3 development branch, unless
   5  someone wants to assume responsibility for it. When the new version of
   6  mSQL is released we might reconsider it, but there has been no demand
   7  for a mSQL based Wiki so far. --Steve Wainstead, swain@panix.com
   8  
   9  
  10  mSQL support is fairly stable. However, due to the limitations of
  11  mSQL's SQL syntax, certain features found in the MySQL and Postgresql
  12  versions are not available. This is not to say they can't be done, but
  13  it will require a lot more code in msql.php to compensate for the lack
  14  of advanced SQL syntax. Simplicity is one of mSQL's virtues however.
  15  
  16  Setting up mSQL is beyond the scope of this document. See
  17  http://www.hughes.com.au/ for information on downloading and
  18  instructions.
  19  
  20  Create the database. You might need system privledges to do this:
  21  
  22  [root@localhost phpwiki]# msqladmin create wiki
  23  Database "wiki" created.
  24  [root@localhost phpwiki]# 
  25  
  26  Load the database schema (here I'm in the phpwiki/ directory created
  27  after untarring the application):
  28  
  29  [swain@localhost phpwiki]$ msql wiki < schemas/minisql-initialize.sql
  30  
  31  You will see a few error messages like this: 
  32  
  33  mSQL >     -> 
  34  
  35  ERROR : Unknown table "wiki"
  36  
  37  This is normal because the schema file drops the table and then
  38  creates it... dropping a nonexistent table is a nonfatal error and you
  39  don't have to worry about it. You should see a lot of these:
  40  
  41  mSQL >     ->     -> 
  42  Query OK.  1 row(s) modified or retrieved.
  43  
  44  
  45  
  46  
  47  mSQL >     -> 
  48  Bye!
  49  
  50  
  51  
  52  Now the database is created; edit lib/config.php and comment out the
  53  DBM file settings. Uncomment the mSQL settings, making sure the values
  54  are correct.
  55  
  56  That should be all! Try accessing your Wiki now. Read INSTALL and
  57  README for more information, plus the comments in lib/config.php.
  58  
  59  --Steve Wainstead
  60  swain@panix.com
  61  
  62  $Id: INSTALL.mSQL,v 1.3 2004/07/25 17:46:44 dfrankow Exp $