Instiki
Migrating to MySQL (Rev #3)

Skip the Navigation Links | Home Page | All Pages | Recently Revised | Authors | Feeds | Export |

]

So you’ve been running Instiki, for a while, with the default SQLite database engine. Now you’ve decided to migrate to a beefier alternative, like MySQL. Here’s how to migrate your data (based on an article by Al Hoang).

1. Set an environment variable in your shell.

   • Under sh and its cousins (bash, zsh, etc) type

     % RAILS_ENV=‘production’

   • Under csh and its cousins (tcsh, etc) type

     % setenv RAILS_ENV production

2. Export your database to dump/fixtures/*.yml

    % rake db:fixtures:export_all

3. Edit config/database.yml, replacing

    production:
   adapter: sqlite3
   database: db/production.db.sqlite3

   with something along the lines of

    production:
   adapter: mysql
   database: your_db_name
   username: your_db_username
   password: your_db_password
   host: 127.0.0.1
   port: 3306

   (The precise details will depend on your setup.)

4. Create a database in MySQL, with the same name as the one you gave in database.yml, using something like

    % echo "create database your_db_name" | mysql -u your_db_username -p your_db_password

5. Initialize the database tables and reimport your data

    % rake migrate
    % rake db:fixtures:import_all

Revision from September 23, 2007 01:54:04 by Jacques Distler

Forward in time (33 more) | Back in time (2 more) | See current | See changes | History | Rollback | View: Source | Linked from: Upgrading, News, Installing on Shared Hosts, Known Bugs, Run on Port 80