The Perl Toolchain Summit needs more sponsors. If your company depends on Perl, please support this very important event.

NAME

cgi-wiki-setupdb - Set up a database storage backend for CGI::Wiki.

SYNOPSIS

  # Set up or update the storage backend, leaving any existing data
  # intact. Useful for upgrading from old versions of CGI::Wiki to
  # newer ones with more backend features.

  cgi-wiki-setupdb --type postgres
                   --name mywiki \
                   --user wiki  \
                   --pass wiki \
                   --host 'db.example.com'

  # Clear out any existing data and set up a fresh backend from scratch.

  cgi-wiki-setupdb --type postgres
                   --name mywiki \
                   --user wiki  \
                   --pass wiki  \
                   --force-preclear

DESCRIPTION

Takes three mandatory arguments:

type

The database type. Should be one of 'postgres', 'mysql' and 'sqlite'.

name

The database name.

user

The user that connects to the database. It must have permission to create and drop tables in the database.

two optional arguments:

pass

The user's database password.

host

The hostname of the machine the database server is running on (omit for local databases).

and one optional flag:

force-preclear

By default, this script will leave any existing data alone. To force that to be cleared out first, pass the --force-preclear flag.

AUTHOR

Kake Pugh (kake@earth.li).

COPYRIGHT

     Copyright (C) 2002-2003 Kake Pugh.  All Rights Reserved.

This code is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

SEE ALSO

CGI::Wiki