Clone database or run sql dump on the fly in laravel 4

Question

I have a big project in laravel 4, and i need to make new database with lot of tables on the fly. I can make empty database on the fly, but how to fill it up with tables? I cant use migrations on the fly, because this application have lot of permissions, so user cant pass them.

First option is to clone empty database (empty from data but with tables). Second option is run sql dump file on the fly.

Can someone explain me how to do that?

score 0 · Accepted Answer · edited May 23 '17 at 12:28

0

Laravel provides an option to fill the database through seeding . check the docs .

Laravel also includes a simple way to seed your database with test data using seed classes. All seed classes are stored in app/database/seeds. Seed classes may have any name you wish, but probably should follow some sensible convention, such as UserTableSeeder, etc. By default, a DatabaseSeeder class is defined for you. From this class, you may use the call method to run other seed classes, allowing you to control the seeding order.

after defining the seed class . you can seed the database through the command

php artisan db:seed

check this blog post on how to use seeing and also faker library to prefill databased with real like test data.

if you can't use command line. you can call the seed command from your code . check this thread .

edited May 23 '17 at 12:28

Community

1
1

answered Apr 22 '15 at 10:25

Sojan Jose

3,168
6
33
52

I cant use artisan on the fly, because it is on another server and there users hasnt got permissions. I need to clone db on the fly without comand line comands – user3921996 Apr 22 '15 at 10:50
@user3921996 then i guess importing the sql dump file be your option . – Sojan Jose Apr 22 '15 at 10:55
@user3921996 you can call artisan seed from the code `Artisan::call('db:seed');` – Sojan Jose Apr 22 '15 at 10:56
sql dump is onption, but how to do that in code? I cant find any information about that – user3921996 Apr 22 '15 at 10:59
@user3921996 check my second comment and update to anser – Sojan Jose Apr 22 '15 at 11:00
@user3921996 seed command can only fill databases with values, if you want to create databases, you need migrations . again you call migrations with `Artisan::call('db:migrate')` – Sojan Jose Apr 22 '15 at 11:12
A cant use migrations. I have two options, database clone and sql dump. Thats all. – user3921996 Apr 22 '15 at 11:37
1

@user3921996 http://stackoverflow.com/questions/19751354/how-to-import-sql-file-in-mysql-database-using-php – Sojan Jose Apr 22 '15 at 11:40

Clone database or run sql dump on the fly in laravel 4

1 Answers1