If you intention is to be able to use MySQL for your production server
Postgres for your development then you could just set them up in your
config/database.yml file as such.
If you use ‘rake db:schema:dump RAILS_ENV=development’ against your
Postgres/dev database, this will create a rubified schema of your
You could then use ‘rake db:schema:load RAILS_ENV=production’ against
MySQL/env database. (This is presuming that you have set your
database.ymlto reflect these configurations.)
btw…this will not give you a true dump of your database (with all of
data), just the schema.
If the problem is that you do not have shell access to your server and
cannot call ‘rake’ from the command line there, but have to update the
database schma through some other web based sql loader, then I would
recommend just switching your local database to whatever you are using
your production and save yourself the frustration. Simply solve the
and solve the problem simply as they say.
Hope this helps.
On 8/28/07, Christian M. [email protected] wrote:
also try ‘rake -T’ for a list of helpful rake tasks
The reason that I ask is that my ROR hosting (servage) does not seem
David Andrew T.http://dathompson.blogspot.com
David Andrew T.