function db_executeSqlFile($filename) { $dsn = Config::get('global.database'); $parts = db_splitDsn($dsn); $command = sprintf("cat {$filename} | mysql -u %s %s %s", $parts['user'], $parts['database'], $parts['password'] ? "-p" . $parts['password'] : ''); OS::executeAndAssert($command); }
public static function changeDatabase($versionName) { $lvs = pref_getLocVersions(); if ($versionName == $lvs[0]->name || !$versionName) { $dbInfo = db_splitDsn(); $dbName = $dbInfo['database']; } else { $lv = new LocVersion(); $lv->name = $versionName; $dbName = pref_getLocPrefix() . $lv->getDbName(); } db_changeDatabase($dbName); }
public static function changeDatabase($versionName) { $lvs = Config::getLocVersions(); if ($versionName == $lvs[0]->name || !$versionName) { $dbInfo = db_splitDsn(); $dbName = $dbInfo['database']; } else { $lv = new LocVersion(); $lv->name = $versionName; $dbName = Config::get('global.mysql_loc_prefix') . $lv->getDbName(); } db_changeDatabase($dbName); }
function db_init() { $functestFile = pref_getSectionPreference('functest', 'functestLockFile'); if ($functestFile && file_exists($functestFile)) { $dsn = pref_getSectionPreference('functest', 'functestDatabase'); } else { $dsn = pref_getServerPreference('database'); } $parts = db_splitDsn($dsn); ORM::configure(sprintf("mysql:host=%s;dbname=%s", $parts['host'], $parts['database'])); ORM::configure('username', $parts['user']); ORM::configure('password', $parts['password']); // If you enable query logging, you can then run var_dump(ORM::get_query_log()); // ORM::configure('logging', true); ORM::configure('driver_options', array(PDO::MYSQL_ATTR_INIT_COMMAND => 'SET NAMES utf8')); }
<?php require_once __DIR__ . '/../phplib/util.php'; $SQL_FILE = Config::get('global.tempDir') . '/dex-database.sql'; $GZ_FILE = Config::get('global.tempDir') . '/dex-database.sql.gz'; $LICENSE = util_getRootPath() . '/tools/dumpDatabaseLicense.txt'; $parts = db_splitDsn(); $COMMON_COMMAND = sprintf("mysqldump -h %s -u %s --password='******' %s ", $parts['host'], $parts['user'], $parts['password'], $parts['database']); $schemaOnly = array('RecentLink', 'Cookie', 'UserWordBookmark', 'DefinitionSimple', 'history_Comment', 'history_Definition'); $currentYear = date("Y"); // Full/Public dump: the public dump omits the user table, which contains emails and md5-ed passwords. $doFullDump = false; for ($i = 1; $i < count($argv); $i++) { $arg = $argv[$i]; if ($arg == "--full") { $doFullDump = true; } else { if ($arg == '--public') { $doFullDump = false; } else { OS::errorAndExit("Unknown flag: {$arg}"); } } } log_scriptLog('Running dumpDatabase.php with argument ' . ($doFullDump ? 'full' : 'public')); $dbName = $parts['database']; $tablesToIgnore = ''; foreach ($schemaOnly as $table) { $tablesToIgnore .= "--ignore-table={$dbName}.{$table} "; } if ($doFullDump) {