我目前正在編寫(xiě)一個(gè)腳本，只需單擊兩次即可輕松導(dǎo)入備份，但我找不到有關(guān)如何導(dǎo)入和 .gz 文件的任何信息。.sql 文件工作得很好，但如果我要解壓縮它，我也可以使用 phpmyadmin 導(dǎo)入它。當(dāng)我當(dāng)前嘗試導(dǎo)入 .gz 文件時(shí)，我只是收到一個(gè)巨大的不可讀字符錯(cuò)誤。我怎樣才能導(dǎo)入 .gz 文件這里的重點(diǎn)是它是一個(gè)基于 WEB 的導(dǎo)入器$userName = "root";$password = "";$dbName = "test"; $conn = @new mysqli($serverName,$userName,$password,$dbName); if ($conn->connect_errno) { echo "Failed to connect to MySQL: " . $con->connect_errno; echo "<br/>Error: " . $con->connect_error;} $fileName = "189_dump.sql.gz"; $temp = ""; $lines = file($fileName); foreach($lines as $line){ if(substr($line, 0, 2) == '--' || $line == '') continue; $temp .= $line; if(substr(trim($line), -1, 1) == ';'){ $conn->query($temp) or print('Error performing query \'<strong>' . $temp . '\': '. '<br /><br />'); $temp = ""; } } echo "imported db (or not)";?>
2 回答
泛舟湖上清波郎朗
TA貢獻(xiàn)1818條經(jīng)驗(yàn) 獲得超3個(gè)贊
這就是我修復(fù)它的方法：
$lines = gz文件($fileName);
<?php
class reader{
public $dbName;
public $fileName;
public function import($dbName, $fileName){
$serverName = "localhost";
$userName = "root";
$password = "";
$conn = new mysqli($serverName,$userName,$password,$dbName);
$temp = "";
$lines = gzfile($fileName);
foreach($lines as $key => $line ){
if(substr($line, 0, 2) == '--' || $line == '') continue;
$temp .= $line;
if(substr(trim($line), -1, 1) == ';'){
$conn->query($temp) or print('Error performing query \'<strong>' . $temp . '\': '. '<br /><br />');
$temp = "";}
}
echo "<script>alert('Database Imported')</script>";
}
}
$bestand = new reader();
# dbname | file name
$bestand->import("test", "testdb.sql.gz");
?>
富國(guó)滬深
TA貢獻(xiàn)1790條經(jīng)驗(yàn) 獲得超9個(gè)贊
如果您允許 system() 您可以：
<?php
system("gzip -dc < ".$file." | mysql -u $dbuser -p$dbpassword $dbname");- 2 回答
- 0 關(guān)注
- 263 瀏覽
添加回答
舉報(bào)
0/150
提交
取消