// Set $db_create to 0 to NOT create the database.
$db_create = 1;
// Communication protocol tu use. For pgsql, you can use 'unix' instead of
// 'tcp' to use Unix Domain Sockets instead of TCP/IP.
$db_protocol = "tcp";
/**************************
* DBMS specific options
***************************/
//****ORACLE*****
// Home directory path where Oracle is installed if it is running in the local machine.
// Default value: value of the environment variable ORACLE_HOME
$oci8_home = "";
/**************************
* End of database settings
***************************/
include_once "MDB.php";
MDB::loadFile("Manager");
$schema_file = "mrbs.schema.xml";
$variables = array("database_name" => $db_database, "database_create" => $db_create);
$dsn = array("phptype" => $dbsys, "username" => $db_login, "password" => $db_password, "hostspec" => $db_host, "protocol" => $db_protocol, "port" => $db_port);
$options = array("HOME" => $oci8_home, "optimize" => 'portability');
$manager = new MDB_manager();
$manager->connect($dsn, $options);
$success = $manager->updateDatabase($schema_file, $schema_file . ".before", $variables);
if (MDB::isError($success)) {
echo "Error: " . $success->getMessage() . "<BR>";
echo "Error: " . $success->getUserInfo() . "<BR>";
}
if (count($manager->warnings) > 0) {
echo "WARNING:<BR>", implode($manager->getWarnings(), "!\n"), "\n";
}
*
*/
define('LIB_MDB', '');
require_once LIB_MDB . 'MDB.php';
MDB::loadFile('Manager');
$mdb_schema_file = 'mdb-schema.xml';
$dbName = 'copixwebapp';
// set the array of "variables" in the $schema_file
$variables = array();
// set the array of "options" for the DBMS
// Note: it's possible to set options with
$options = array('UseTransactions' => true, 'DefaultTableType' => 'INNODB', 'persistent' => false, 'debug' => 5);
// set the array of information for the connexion to the DBMS
// Note: DSN format = DBMS_type://user_name:password@hostserver.DB_name
$dbinfo = array('phptype' => 'mysql', 'username' => 'root', 'hostspec' => 'localhost', 'password' => 'pierre');
$manager = new MDB_manager();
$manager->connect($dbinfo, $options);
$success = $manager->updateDataBase($mdb_schema_file, '', $variables);
if (MDB::isError($success)) {
echo 'Error: ' . $success->getMessage() . '\\n<br>';
echo $success->toString() . " \n<br>";
}
if (count($manager->warnings) > 0) {
echo 'Warning: \\n' . implode($manager->getWarnings(), '!\\n') . '\\n';
}
$manager->disconnect();
$dbLink = mysql_pconnect('localhost', 'root', 'pierre');
// @todo: ici il faudrait en fait récupérer le nom de la BDD figurant dans
// le schéma !
$dbResult = mysql_select_db($dbName, $dbLink);
/*
