php - Migrate multiple databases with Propel -
i maintaining system many databases. 1 “central" db, , many other “client” dbs. each time client registers, create client db using sql file. system using propel + php + mysql.
now problem is, there changes when version-up. it’s possible use propel migration central db, there many client dbs, , in propel.yaml/ propel-config.php have 1 connection string client this:
$manager = new \propel\runtime\connection\connectionmanagersingle(); $manager->setconfiguration(array( 'classname' => 'propel\\runtime\\connection\\connectionwrapper', 'dsn' => 'mysql:host=127.0.0.1;dbname=' . $shopdbname . ';charset=utf8', 'user' => 'dba', 'password' => ‘******', 'attributes' => array( 'attr_emulate_prepares' => false, ), ));
in $shopdbname global variable identified string sent client devices.
so, how can automate process of migration client dbs in case, please?
Comments
Post a Comment