from an Alexey Verkhovsky email of 19 Mar 2006 to instiki-users@rubyforge.org—
...the way to do it depends on which database you are using.
For SQLite (default option), backing it up is simply a matter of copying the database file, which by default is located at instiki-0.11.0/db/production.db.sqlite3.
This location, by the way, can be changed by editing instiki-0.11.0/config/database.yml, specifically the last line in the following section:
production: adapter: sqlite3 database: db/production.db.sqlite3
Note: all whitespace in database.yml file format is important, especially the indentation.
(end of quote)