how to add a .sql database to an existing db in Laravel?

Question

I'm relatively new at Laravel development and I have a large .sql file to add on my existing db (the DB is a list of city in Italy with their relative lat and long data). Anyone know how can I add the file with a seed? thank you and sorry for the question :)

Read about Laravel Migrations: laravel.com/docs/5.8/migrations and Seeding laravel.com/docs/5.8/seeding — ash__939
– ash__939, Commented Jan 10, 2020 at 14:15

user2094178 · Accepted Answer · 2020-01-10 14:35:01Z

1

To add a .sql file with a seed, you have to use the following approach:

DB::unprepared(file_get_contents(database_path('seeds/cities.sql'));

This will not work well with very large files.

answered Jan 10, 2020 at 14:35

user2094178

9,47410 gold badges45 silver badges70 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to add a .sql database to an existing db in Laravel?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related