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

Question

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

When you run the artisan migrate command, how your terminal looks? What does it write? — Fractaliste
– Fractaliste, Commented Nov 27, 2013 at 13:11
Nothing to migrate. But I think command is running on running on local machine. — niran
– niran, Commented Nov 27, 2013 at 13:16
No I did not run that command. Do I need to run that? what it does — niran
– niran, Commented Nov 27, 2013 at 13:21
You should read this chapter of the documentation (and the Schema builder one's too). — Fractaliste
– Fractaliste, Commented Nov 27, 2013 at 13:25

danronmoon · Accepted Answer · 2021-11-20 12:12:44Z

64

with the new official php buildpack 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".

edited Nov 20, 2021 at 12:12

danronmoon

3,8735 gold badges36 silver badges58 bronze badges

answered May 15, 2014 at 14:08

dwenaus

3,3262 gold badges29 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Deric Lima Over a year ago

I suggest you to use the "post-install-cmd" section instead. "post-update-cmd" will be called only when running composer update. You don't want to run composer update in production.

Aaron Gustafson · Accepted Answer · 2014-01-30 15:47:29Z

15

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

answered Jan 30, 2014 at 15:47

Aaron Gustafson

6126 silver badges11 bronze badges

2 Comments

niran Over a year ago

not worked for me :) got this error. bash: -c: line 0: syntax error near unexpected token (' bash: -c: line 0: C:/Program Files (x86)/Git/app/php/bin/php C:/Program Files (x86)/Git/app/www/artisan migrate'

Hernan Rajchert Over a year ago

Maybe they change it recently, but I had to do this: heroku run php /app/artisan migrate

Alen MJ · Accepted Answer · 2016-05-24 04:42:41Z

7

Here is a complete example, and will solve "nothing to migrate issue" that comes in for Heroku,

heroku run php artisan migrate --path=database/migrations --app application-name

application-name is your Heroku APP name

answered May 24, 2016 at 4:42

Alen MJ

1361 silver badge5 bronze badges

Comments

Roshan Pal · Accepted Answer · 2014-12-31 16:50:23Z

6

This line will give you access to all laravel artisan commands:

heroku run php artisan

answered Dec 31, 2014 at 16:50

Roshan Pal

7,9762 gold badges15 silver badges12 bronze badges

Comments

usmany · Accepted Answer · 2019-12-28 08:40:23Z

3

If you have multiple applications on a heroku server, you can do:

heroku run bash -a application-name

this will open a bash container for that specific application, and you can run any command inside this container. i.e

php artisan migrate:refresh --seed

Obviously you'll first need to make sure that you are already logged in to the heroku cli.

answered Dec 28, 2019 at 8:40

usmany

1443 silver badges14 bronze badges

1 Comment

Olotin Temitope Over a year ago

This answer makes a lot of sense. It allows me to run Linux commands and execute artisan quite well

lifekent · Accepted Answer · 2016-01-29 16:39:26Z

1

I would recommend to run migration as a part of build process. As it should be. Take a look at https://github.com/lifekent/heroku-buildpack-laravel. Official build pack with easy yo use support for running artisan commands

edited Jan 29, 2016 at 16:39

answered Jan 28, 2016 at 9:40

lifekent

3001 silver badge7 bronze badges

Comments

RickyS · Accepted Answer · 2022-09-10 14:13:05Z

0

heroku run php artisan migrate -a {your app name}

answered Sep 10, 2022 at 14:13

RickyS

112 bronze badges

Collectives™ on Stack Overflow

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

7 Answers 7

1 Comment

2 Comments

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

1 Comment

2 Comments

Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related