How to run a migration?

That migration has already been run, you need to add a new one to amend the table.

If you want it to modify it and run it again, you need to do:

php artisan migrate:refresh

But, you will lose your data.

Are you seeding your data? (I recommend that you do.)

If you are you can do this:

php artisan migrate:refresh --seed

Mick

You may try this-

• in migrations table, delete the last / the respective tables record that's column you have changed.

Now run php artisan migrate and hope you will get the changes.

Of course, you will loose your data for that table in this case.

Hi! Thanks for the replies!

@phpMick, how do I amend my change? What is seeding?

https://laravel.com/docs/5.4/seeding

You make the change by amending the original migration file. php artisan migrate:refresh will dump the table and create it again.

I prefer to work like this, so you don't end up with a load of migrations.

Seeding is putting the data in your db.

@phpMick Ok, but then that is what I am doing, amending the changes. That is I change for example the schema in the migration file for the table. But somehow 'php artisan migrate' doesn't seem to recognise the change. Do I need to change the filename of the migration file or something like that?

When a migration has been run, a record is created (in the migrations table), so that this migration does not get run again.

If you want the same migration to get executed again:

php artisan migrate:refresh

"The migrate:refresh command will roll back all of your migrations and then execute the migrate command. This command effectively re-creates your entire database:"

I would read all of this again:

https://laravel.com/docs/5.4/migrations