Laravel 5.1 refresh and seed a single table

Question

I'm looking to refresh and seed a single table in Laravel 5.1. Is this even possible?

I have tried the below, but it gives an error (incorrect syntax).

php artisan migrate:refresh --path=database/migrations/CreateTableTimesheet

If I use: php artisan migrate:refresh it just says:

Nothing to migrate

Zakaria Acharki · Answer 1 · 2016-09-06T08:02:07.160

You could use migrate:refresh command that will roll back all of your migrations and then execute the migrate command. This command effectively re-creates your entire database :

php artisan migrate:refresh

And you may use the --class option to specify a specific seeder class to run individually :

php artisan db:seed --class=UserTableSeeder

The full code will be :

php artisan migrate:refresh
php artisan db:seed --class=UserTableSeeder

Hope this helps.

score 15 · Answer 2 · answered Oct 07 '19 at 17:21

15

Its better to truncate your same table first and then seed:-

public function run()
{
    Table::truncate();
    //seed your table here
}

then you can run your same seeder like this:-

php artisan db:seed --class=YourSeeder

answered Oct 07 '19 at 17:21

harbrinder_singh

454
5
7

If you are using Eloquent for a model named Users, it's going to be Users::on()->truncate(); . – Jagadish Nallappa Nov 02 '21 at 07:46

score 4 · Answer 3 · answered Nov 04 '15 at 18:33

4

Maybe first just backup the database, drop it and check if whole seeding, migrating and refreshing mechanic works. But first dump artisan autoload.

answered Nov 04 '15 at 18:33

2

A great way to get your answer up-voted is to include an example or a link to an example. – c0y0teX Nov 04 '15 at 18:44

score 3 · Answer 4 · answered May 12 '20 at 09:42

I don't think any answer so far addresses the question of migrating and seeding a single table. So, given the migration file database/migrations/create_foo_table.php and the seed file database/seeds/FooTableSeeder.php, which contains the FooTableSeeder seed class, you can do the following:

php artisan migrate:refresh --path=database/migrations/create_foo_table.php
php artisan db:seed --class=FooTableSeeder

This will rollback, migrate and seed your Foo table. See: rolling back migrations and running seeders in the Laravel 5.1 documentation (at the time of writing this, Laravel 7.x is out and the syntax has not changed).

score 1 · Answer 5 · answered Dec 25 '19 at 10:11

1

php artisan tinker


>>> App\Status::truncate()

Will clear the statuses table

So you can do


>>> App\{MODEL_CLASS}::truncate()

I found this quite useful when I don't want to clear all the tables, especially users.

answered Dec 25 '19 at 10:11

Frank Decker

11
2

score 1 · Answer 6 · answered Apr 19 '22 at 15:48

1

include full table name
example

php artisan migrate:refresh --path='database/migrations/2014_10_12_000000_create_table_timesheet.php'

answered Apr 19 '22 at 15:48

Tejas

48
2
8

score 1 · Answer 7 · answered May 02 '23 at 08:00

Tips for run migration,roleback,refresh and seeder specific file for Laravel Framework

Migrate

php artisan migrate --path=/database/migrations/fileName.php

Roolback

php artisan migrate:rollback --path=/database/migrations/fileName.php

Refresh

php artisan migrate:refresh --path=/database/migrations/fileName.php

Seeder

php artisan db:seed --class=classNameTableSeeder

Thanks

DevonDahon · Answer 8 · 2020-06-01T22:03:29.397

You can do it in two steps:

Refresh your specific table:

php artisan migrate:refresh --path=database/migrations/00_create_foo_table.php

Seed tables set in database/seeds/DatabaseSeeder.php:

composer dump-autoload
php artisan db:seed

=== Extra information ===

You can comment the seeders you don't want to use in DatabaseSeeder.php:

<?php

use Illuminate\Database\Seeder;

class DatabaseSeeder extends Seeder
{
    /**
     * Seed the application's database.
     *
     * @return void
     */
    public function run()
    {
        $this->call([
            FooSeeder::class,
            // BarSeeder::class,
            // UserSeeder::class,
        ]);
    }
}

In this example, only database/seeds/FooSeeder.php will be passed.

Laravel 5.1 refresh and seed a single table

8 Answers8