Is there any Laravel way to execute a .SQL file to load data

mysql eloquent laravel-5.1 laravel-artisan
Volatil3 picture Volatil3 · Nov 20, 2015 · Viewed 11.5k times · Source

I have historical data that I want to load in new DB.

I could do it by running MySQL command but I am interested to know whether there are artisan commands to do it?

Answer

djt picture djt · Nov 20, 2015

There isn't a way to import a DB dump out-of-the-box using artisan. However, you could create a custom artisan command:

php artisan make:console DbImportCommand

and then have it issue a command like:

DB::unprepared(file_get_contents('full/path/to/dump.sql'));

However, it may be advantageous to create a command that runs a seeder (or set of seeders).

php artisan make:console importHistoricalData

and then have that run specific seeders:

$this->call(OldCompanySeeder::class);
$this->call(OldEmployeeSeeder::class);
// etc....

If you wipe the database at some point, or move to a new environment, it's as simple as just running the seeders again.

Related questions

How to do this in Laravel, subquery where in

How can I make this query in Laravel: SELECT `p`.`id`, `p`.`name`, `p`.`img`, `p`.`safe_name`, `p`.`sku`, `p`.`productstatusid` FROM `products` p WHERE `p`.`id` IN ( SELECT `product_id` FROM `product_category` WHERE `category_id` IN ('223…

Read More
Select all from table with Laravel and Eloquent

I am using Laravel 4 to set up my first model to pull all the rows from a table called posts. In standard MySQL I would use: SELECT * FROM posts; How do I achieve this in my Laravel 4 model? See below …

Read More
Is there a way to "limit" the result with ELOQUENT ORM of Laravel?

Is there a way to "limit" the result with ELOQUENT ORM of Laravel? SELECT * FROM `games` LIMIT 30 , 30 And with Eloquent ?

Read More