Search code examples
herokularavel-4heroku-toolbeltheroku-postgres

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

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

Solution

  • It took a little digging, but I was able to use it by running this command:

    heroku run /app/php/bin/php /app/www/artisan migrate

    So the lesson I learned was this: prefix all remote artisan commands with heroku run /app/php/bin/php /app/www/artisan