DEV Community

Update existing table's column with migration without losing data in Laravel

M H Hasib on May 20, 2021

Before going to start our coding we need to know about Laravel Migration and how it helps us. First of all, if we want to build a project. We need...

Read full post

Mukul Sharma • Nov 21 '22

I though with ORM it's only one way. Thanks for this great article.

Brian Kanyi Karanja • Apr 20 '23

Well discussed. It worked for me. Thank you

M H Hasib • Aug 7 '23

Thanks.

Fatima Almashhor • Apr 11 '22

Thank you for this . it save my life.

Hassan Zekkouri • Nov 29 '21

Thank you. It saved me time.

Arvind Kumar • Jan 5 '22

Thanks!

M H Hasib • Jan 16 '22

Welcome Brother.

krognome • Feb 9 '23

So I'm pretty damns sure if I run php artisan migrate it will without any question run all my migration files and delete all of the data. I see people thanking you here like they did not lose all their data but it always removes all the data every time I run that command. So I simply run the 1 migration file with: php artisan migrate --path=/database/migrations/full_migration_file_name_migration.php

JackLeEmmerdeur • Feb 17 '23 • Edited

I just tried this. Before I always used php artisan migrate:refresh, but I needed schema altering with data retention.

For me php artisan migrate only applied the new migration and left the data of unmodified tables untouched, opposed to the above refresh-modifier.

Maybe it has been, like you described, in an old Laravel version?
If unsure there is also php artisan migrate --pretend. It shows the SQL the migrations would produce without executing them.