debian man page for wiki-toolkit-setupdb

WIKI-TOOLKIT-SETUPDB(1p)				User Contributed Perl Documentation				  WIKI-TOOLKIT-SETUPDB(1p)

NAME
       wiki-toolkit-setupdb - Set up a database storage backend for Wiki::Toolkit.

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

	 wiki-toolkit-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.

	 wiki-toolkit-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.
	    Copyright (C) 2006 the Wiki::Toolkit team. 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
       Wiki::Toolkit

perl v5.14.2							    2011-09-25						  WIKI-TOOLKIT-SETUPDB(1p)