Laravel Database migration procedure

Question

I am currently using Laravel 5.4. I have a separate database per client. I would like to run database migrations in all my client databases. The database names are in the format of clientdb_{clientid}. I have tried using

Config::set("database.connections.mysql", ["database" =>
 "clientdb_".$client['id'],
"username" => "root","password" => ""]);

 $this->callSilent('migrate', 
[ '--path' => 'database/migrations/clients','--database'=>'clientdb_'.$client['id']]);

but I am getting exception called

[InvalidArgumentException] Database [clientdb_1] not configured.

Don't Panic · Accepted Answer · 2017-09-03 11:02:31Z

1

The code you show is configuring the connection labelled mysql. I think what you are really trying to do is configure a new database connection called clientdb_1:

Config::set("database.connections.clientdb_" . $client['id'], [
    "database" => "clientdb_" . $client['id'],
    "username" => "root",
    "password" => ""
]);

answered Sep 3, 2017 at 11:02

Don't Panic

14.1k5 gold badges35 silver badges55 bronze badges

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

5 Comments

Ganesh Over a year ago

in mysql driver i have configured the db called syncclient. but i would like to access dynamically using config::set aremy clientdb's

Don't Panic Over a year ago

@ganesh Sorry, I don't understand. Is this a new question? Does my answer help with the question you asked initially?

Ganesh Over a year ago

this is the same question. scenario:: I have 1db per client. i want to access the client db's without configuring it in the config/database.php file i would like to access all the database is there anyway???

Don't Panic Over a year ago

@ganesh I have answered that question.

Ganesh Over a year ago

is there anyway i would like to access without configuring in database.php file @Don't Panic

user223321 · Accepted Answer · 2017-09-03 06:59:11Z

0

Looks like the database is not configured in your config/database.php file

answered Sep 3, 2017 at 6:59

user223321

1531 silver badge16 bronze badges

1 Comment

Ganesh Over a year ago

yeah i have configured a permanent db in env and database.php. but these are runtime db i would like to access. how to make it possible @Abhishek Vyas

Collectives™ on Stack Overflow

Laravel Database migration procedure

2 Answers 2

5 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related