Skip to main content
Quick Tip

A simple way to seed a database

If you want to seed data from SQL file, no need to transform all those "insert into..." statements into seeders.

You can just run DB query directly from the seeder, calling that SQL file.

class SomeSeeder extends Seeder
{
public function run()
{
\DB::unprepared(
file_get_contents(__DIR__ . './dump.sql')
);
}
}

Enjoyed This Tip?

Get access to all premium tutorials, video and text courses, and exclusive Laravel resources. Join our community of 10,000+ developers.

Recent Courses on Laravel Daily

Testing in Laravel 13 For Beginners

26 lessons
1 h 41 min read

Queues in Laravel 13

18 lessons
1 h 12 min read

How to Build Laravel 13 API From Scratch

30 lessons
1 h 23 min