Faster way to pull data from Heroku not using Taps... part II

Question

I've been trying to use the solution described in this post: Is There A Faster Way To Pull Production Data From Heroku Than Taps?

But I use Mysql locally, other than PostgreSQL. Is there a way to use that solution but still using Mysql for development?

Thank you.

Answer 1

Given the inconsistencies between Mysql and Postgres (I've just experienced pain on a project), I would advise installing Postgres locally. Then you could write a simple worker script using a rake task / delayed job that dumps the current database state to Amazon S3. Running this nightly gives you 24hr backups, which might be all you need in many scenarios. Or you could run it on demand so you can download it.