How to deploy local MySQL database to Heroku

by

Firstly Heroku natively uses postgres. Life will be easier for you if you use that locally.

You can import / export postgres dump files from heroku as described here: https://devcenter.heroku.com/articles/heroku-postgres-import-export

If you really want to use mysql, you have two paths to follow.

1) Run mysql locally, but convert to postgres when migrating to Heroku using the mysql2psql gem, as described here: https://devcenter.heroku.com/articles/heroku-mysql

2) Use a mysql addon like https://addons.heroku.com/cleardb

However my recommendation would be to use postgres end to end, as it is baked into Heroku, and you’ll be working with the default ways of using Heroku, not against them.

Postgres is very good too!

More Related Contents:

  1. Remote connect to clearDB heroku database
  2. How do you write a case insensitive query for both MySQL and Postgres?
  3. Ruby on Rails – cannot load such file — mysql2/2.2/mysql2 (LoadError)
  4. get first occurrence of last changed value of a column [closed]
  5. MySQL – Rows to Columns
  6. ROW_NUMBER() in MySQL
  7. How can I temporarily disable a foreign key constraint in MySQL?
  8. Creating a “Numbers Table” in MySQL
  9. MYSQL Select MAX Date inside a join statement
  10. Choosing a stand-alone full-text search server: Sphinx or SOLR? [closed]
  11. Determine which MySQL configuration file is being used
  12. In SQL, how to select the top 2 rows for each group
  13. TRIGGERs that cause INSERTs to fail? Possible?
  14. Mysql query to dynamically convert rows to columns on the basis of two columns
  15. MySql difference between two timestamps in days?
  16. Is there a naming convention for MySQL?
  17. How to integrate Apache Spark with MySQL for reading database tables as a spark dataframe? [closed]
  18. How to set a MySQL row to READ-ONLY?
  19. Finding number position in string
  20. Why does MySQL autoincrement increase on failed inserts?
  21. Case Sensitive collation in MySQL
  22. MySQL: ALTER IGNORE TABLE ADD UNIQUE, what will be truncated?
  23. error code 1292 incorrect date value mysql
  24. How to search for rows containing a substring?
  25. Import CSV to Update only one column in table
  26. Error in MySQL library for Node.js
  27. INSERT INTO Table from multiple tables
  28. Mysql How do you create a clustered index?
  29. Counting associated entries with Sequelize
  30. MySQL data directory location

Leave a Comment