abstract image of ryan

Welcome to ryanwold.net

I recently moved from a self-hosted MySQL database to a free instance of Postgres on Heroku.

This entailed getting the data from the MySQL database into the Postgres database. I found the yaml_db .gem particularly useful here.

  1. run rake db:data:dump to create a db/data.yml file of all the data in your database
  2. change database.yml to the new database's URL - something like postgres://...amazonaws.com...
  3. run rake db:data:load to load the db/data.yml file into the Postgres database