Question 63796 in PhpMyAdmin Question posted in
The official documentation can be found here.

How to delete specific migration and then remigrate that table only in Laravel? – Phpmyadmin

Hy there,

I entered some fields in migration file and then migrated it to phpmyadmin, but lateron I added some more fields in it but I have already entered data in the table. If I drop that table from phpmyadmin, it doesn’t migrate using

php artisan migrate

if I wipe the whole database, I lose the whole data.

php artisan db:wipe

So I just want to get that added fields in my table without lossing my entered data.

Thanks in Advance,
Junaid Ali

If I drop that table from phpmyadmin, it doesn’t migrate using

php artisan migrate

if I wipe the whole database, I lose the whole data.

php artisan db:wipe

So I just want to get that added fields in my table without lossing my entered data.

Tags:

2

Answers


  1. 0

    go to your database and open the table "migrations" then you search and delete the migration from your database and run migrates again.

    If this doesn’t work run this command php artisan migrate:fresh it will delete all your database and then automatically run migrations.

    If this doesn’t work then check in your .env if the database set is the same.

    If none of this works do as @Maksim said.

    Login or Signup to reply.
  2. 0

    If you just wanted to add a new field to a exiting migration, you can just
    Generate a new Migration file then run a php artisan migrate, so that you don’t have to problem about losing you existing data in your database.

    ex.
    //your existing table

    php artisan make:migration create_users_table

    php artisan make:migration add_votes_to_users_table –table=users

    //to add new field (vote)

    then run php artisan migrate to add vote field to your users table

    you can also refer to the laravel documentation for much detailed explanation about generating migrations
    https://laravel.com/docs/8.x/migrations

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search