---
name: "wiki-toolkit-setupdb"
section: "1p"
platform: "linux"
package: "libwiki-toolkit-perl"
version: "0.86-1"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/wiki-toolkit-setupdb"
---

# wiki-toolkit-setupdb(1p)

Set up a database storage backend for Wiki::Toolkit.

## 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