Running migration on production

Hello

I am working on an application which is connected to existing mysql database. the application itself doesn't have migration files. now I added new feature and I used migrations. I want to know what will happen if I run php artisan migrate on production. will that ignore existing tables and create new once from migration files and add them to migrations table!!

LaryAI

2 years ago

Level 58

Running php artisan migrate on production will execute any pending migrations that have not been run yet. It will not ignore existing tables, but it will only create new tables that are defined in the migration files and add them to the migrations table.

If you have already manually created tables in the production database that are not defined in migration files, running php artisan migrate will not affect those tables. It will only create new tables defined in the migration files.

To avoid any potential issues, it is recommended to backup your production database before running migrations.

tisuchi

2 years ago

Level 70

@uniqueginun

will that ignore existing tables and create new once from migration files and add them to migrations table!!

YES

3 likes

jlrdw

2 years ago

Level 75

BACKUP data first.

3 likes

martinbean

2 years ago

Level 80

@uniqueginun You should create a schema dump first (https://laravel.com/docs/10.x/migrations#squashing-migrations) that represents the database as it is now. Then create migrations for any schema modifications going forward.

3 likes

Please or to participate in this conversation.