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) {
