Instiki
Instiki and My SQL

This may be obvious to experts, but it took a while for me to work out how to switch to using My SQL in Instiki. These instructions are best carried out before you first run Instiki, otherwise you will have to copy your data across too.

• Edit the Instiki file database.yml (.../rails_apps/instiki-0.11.0/config in my case) to switch from sqllite to My SQL. Something like this:

development:
  adapter: mysql
  host: localhost
  database: instiki_dev
  username: root
  password:

test:
  adapter: mysql
  host: localhost
  database: instiki_test
  username: root
  password:

production:
  adapter: mysql
  host: localhost
  database: instiki
  username: root
  password:

# "Out of the box", Instiki stores it's data in sqlite3 database. Other options are listed below.
#production:
#  adapter: sqlite3
#  database: db/production.db.sqlite3

• Create an empty database ‘instiki’ in My SQL (assuming production version)

• From a command prompt in the instiki root (.../rails_apps/instiki-0.11.0), and with Ruby on your path, type rake migrate. This creates the database tables. (Maybe use ruby script/create_db – I’ve not tried that one though.)

• From the same command prompt, run instiki.cmd (or ruby instiki.rb if you’re in Unix)

• take a look at http://localhost:2500

Migrating to My SQL AND keeping your data

How go migrate a currently running instiki and its data to MySQL