Welcome Guest | Login

Configure SQLite

Hi!

This is the first time I try to deploy a Rails app and I'm having some problems. The database I used in my app was SQLite, not MySQL. I couldn't find any tutorial (nor another thread in this forum) that explained how to configure a SQLite database, and I don't find any way to import my SQLite data into a MySQL database.

How can I configure a SQLite database in HostingRails or, if not possible, how can I import all the data in my database into a MySQL? I tried rake db:migrate RAILS_ENV='production', but it fails.


I'm trying to deploy with Passenger (mod_rails).

Thanks in advance.

Edu

2008-11-12 09:57 AM

Hi Edu,

Make sure that your config/database.yml file contains the following entries

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

and then you can populate your sqlite3 database using the command db:migrate RAILS_ENV='production'. If the issue still persists then paste the exact error message that getting in the console.

2008-11-12 01:53 PM

Thanks Vinayan, it worked fine. I successfully completed the rake db:migrate.

Edu

2008-11-13 12:30 AM


Hello Guest! In order to post you must be an active client with us, please log in or sign up.