I have Magento running on Heroku but the DB is on Dreamhost (because Heroku doesn't host mySQL). I get a Database connection error from Magento whenever I try to connect. Anyone ever done this?
2 Answers
Yes you can, I just wrote a blog post on doing just this http://markshust.com/2012/10/29/deploying-magento-heroku-amazon-rds
See http://wiki.dreamhost.com/Mysql#Connect_to_Your_MySQL_Database_from_Third-Party_Programs instructions for making your mysql instance visible to your heroku app.