• +880 1775004576
  • support@websolutionbd24.com

Laravel Import Large SQL File using Seeder Example

Home Blog Laravel Import Large SQL File using Seeder Example

Laravel Import Large SQL File using Seeder Example

December 19, 2020

Hello Dev,

This example is focused on laravel import large sql file. if you want to see example of laravel import data from sql file then you are a right place. you'll learn laravel seeder large sql file. you can understand a concept of laravel seed from sql file large file.

 

you can easily import large sql file using seeder in laravel 6, laravel 7 and laravel 8 version.

 

If you need to import directly sql file into database then how you will do? and if it's large file then how you can do it. i will give you simple example how to import large sql file using laravel seeder.

 

so let's simply create seeder with following command and write code as bellow:

 

 

php artisan make:seeder ImportTableSeeder

 

 

 

now it's create ImportTableSeeder.php file on seeders folder. so let's update as bellow:

make sure you have one sql file call "data.sql" in public folder

database/seeders/ImportTableSeeder.php

 

 

<?php

 

namespace Database\Seeders;

 

use Illuminate\Database\Seeder;

 

class ImportTableSeeder extends Seeder

{

/**

* Run the database seeds.

*

* @return void

*/

public function run()

{

$sql = public_path('data.sql');

 

$db = [

'username' => env('DB_USERNAME'),

'password' => env('DB_PASSWORD'),

'host' => env('DB_HOST'),

'database' => env('DB_DATABASE')

];

 

exec("mysql --user={$db['username']} --password={$db['password']} --host={$db['host']} --database {$db['database']} < $sql");

 

\Log::info('SQL Import Done');

}

}

 

 

 

now you can easily run with bellow command:

 

 

php artisan db:seed --class=ImportTableSeeder

 

 

 

now it will works for you.

i hope it can help you...

Other Posts