Home > Software design >  Laravel migrate ends up in wrong database
Laravel migrate ends up in wrong database

Time:07-26

I have the following settings in .env

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=unwa
DB_USERNAME=root
DB_PASSWORD=NotForEverybody

When I run

php artisan migrate:fresh

Everything seems to be ok. But when I look at my target database "unwa", it is empty. A die and dump revealed, that I was connected to another database "auction" that happens to be the first (alphabetically) database. I find all my tables in the "auction" database.

How can I correctly configure my target database "unwa"?

CodePudding user response:

Try to delete your cache "php artisan optimize:clear"

CodePudding user response:

I had a system environment variable DATABASE_URL that would point to the auction database. This is why it was targeted by the migrations and it could not be found anywhere in the project. Once I removed that environment variable, the migration started to work as expected.

  • Related