Esempio n. 1
0
function importDump($dumpFile, $dbName, $dbUser = '******', $dbPass = '******', $dbHost = 'localhost')
{
    $commandTemplate = 'mysql --host=%s --user=%s %s %s < %s';
    $dbPassEntry = $dbPass ? '--password='******'';
    if (version_compare(getMySQLVersion(), '5.5.3', '<')) {
        $sql = file_get_contents($dumpFile);
        if (false === $sql) {
            return false;
        }
        $conversionMarker = "#converted";
        if (false === strpos($sql, $conversionMarker)) {
            $sql = "{$conversionMarker}\n" . $sql;
            $sql = preg_replace('(CHARSET=utf8[^\\s]*)', 'CHARSET=utf8', $sql);
            $sql = preg_replace('(COLLATE=utf8[^\\s]*)', 'COLLATE=utf8_bin', $sql);
            if (false === file_put_contents($dumpFile, $sql)) {
                return false;
            }
        }
    }
    $command = sprintf($commandTemplate, $dbHost, $dbUser, $dbPassEntry, $dbName, $dumpFile);
    exec($command, $output, $status);
    return $status !== false;
}
Esempio n. 2
0
</td>
  </tr>
</table>

<a name="w_db"></a>
<!--数据库支持-->
<table>
  <tr><th colspan="4">数据库支持</th></tr>

  <tr>
    <td width="30%">MySQL 数据库</td>
    <td width="20%"><?php 
echo isfun("mysqli_connect");
?>
    <?php 
$mysql_ver = getMySQLVersion();
if (!empty($mysql_ver)) {
    echo "&nbsp;&nbsp;Ver&nbsp;" . $mysql_ver;
}
?>
    </td>
    <td width="30%">ODBC 数据库</td>
    <td width="20%"><?php 
echo isfun("odbc_close");
?>
</td>
  </tr>

  <tr>
    <td>Oracle 数据库</td>
    <td><?php