How to use php artisan migrate command of Laravel4 in Heroku?

heroku laravel-4 heroku-toolbelt heroku-postgres
niran picture niran · Nov 27, 2013 · Viewed 20.6k times · Source

I am suing Heroku dev plan for creating database using PostgreSQL. Database is created in Heroku. After running heroku pg:info command

$ heroku pg:info
=== HEROKU_POSTGRESQL_XXX_URL
Plan:        Hobby-dev
Status:      available
Connections: 1
PG Version:  9.3.1
Created:     2013-11-27 04:00 UTC
Data Size:   6.4 MB
Tables:      0
Rows:        0/10000 (In compliance)
Fork/Follow: Unsupported
Rollback:    Unsupported

Result shows zero tables, which is correct.

In my local machine tables are created by using following command which are supported in Laravel4 framework.

php artisan migrate

php artisan db:seed

But it seems like I cannot run this command in heroku to create table and dump data. Please tel me how can I create a copy of my local database in Heroku.

Thanks all

Answer

dwenaus picture dwenaus · May 15, 2014

with the new official php build pack you just run 

$ heroku run bash
$ php artisan migrate

or just

$ heroku run php artisan migrate

And if you want the migration to happen every time you deploy via git then add "php artisan migrate" to to composer.json in the "post-update-cmd" section of "scripts".

Related questions

heroku - how to see all the logs

I have a small app on heroku. Whenever I want to see the logs I go to the command line and do heroku logs That only shows me about 100 lines. Is there not a way to see complete logs for …

Read More
npm ERR cb() never called

I have a Node.js app hosted on Heroku. Every time I do a git push heroku I get the following error: Counting objects: 14, done. Delta compression using up to 6 threads. Compressing objects: 100% (12/12), done. Writing objects: 100% (12/12), 1.20 KiB, done. Total 12 (delta 8), …

Read More
How to link a folder with an existing Heroku app

I have an existing Rails app on GitHub and deployed on Heroku. I'm trying to set up a new development machine and have cloned the project from my GitHub repository. However, I'm confused as to how to link this folder …

Read More