Edit File by line

<?php

[0] Fix | Delete

/**

[1] Fix | Delete

* Define database parameters here

[2] Fix | Delete

[3] Fix | Delete

$upload_dir = wp_upload_dir();

[4] Fix | Delete

$backup_dirname = $upload_dir['basedir'].'/wp-file-manager-pro/fm_backup';

[5] Fix | Delete

define("BACKUP_DIR", $backup_dirname); // Comment this line to use same script's directory ('.')

[6] Fix | Delete

define("TABLES", '*'); // Full backup

[7] Fix | Delete

define("CHARSET", 'utf8');

[8] Fix | Delete

define("GZIP_BACKUP_FILE", true); // Set to false if you want plain SQL backup files (not gzipped)

[9] Fix | Delete

define("DISABLE_FOREIGN_KEY_CHECKS", true); // Set to true if you are having foreign key constraint fails

[10] Fix | Delete

define("BATCH_SIZE", 1000); // Batch size when selecting rows from database in order to not exhaust system memory

[11] Fix | Delete

// Also number of rows per INSERT statement in backup file

[12] Fix | Delete

/**

[13] Fix | Delete

* The Backup_Database class

[14] Fix | Delete

[15] Fix | Delete

class Backup_Database {

[16] Fix | Delete

/**

[17] Fix | Delete

* Host where the database is located

[18] Fix | Delete

[19] Fix | Delete

var $host;

[20] Fix | Delete

[21] Fix | Delete

/**

[22] Fix | Delete

* Username used to connect to database

[23] Fix | Delete

[24] Fix | Delete

var $username;

[25] Fix | Delete

[26] Fix | Delete

/**

[27] Fix | Delete

* Password used to connect to database

[28] Fix | Delete

[29] Fix | Delete

var $passwd;

[30] Fix | Delete

[31] Fix | Delete

/**

[32] Fix | Delete

* Database to backup

[33] Fix | Delete

[34] Fix | Delete

var $dbName;

[35] Fix | Delete

[36] Fix | Delete

/**

[37] Fix | Delete

* Database charset

[38] Fix | Delete

[39] Fix | Delete

var $charset;

[40] Fix | Delete

[41] Fix | Delete

/**

[42] Fix | Delete

* Database connection

[43] Fix | Delete

[44] Fix | Delete

var $conn;

[45] Fix | Delete

[46] Fix | Delete

/**

[47] Fix | Delete

* Backup directory where backup files are stored

[48] Fix | Delete

[49] Fix | Delete

var $backupDir;

[50] Fix | Delete

[51] Fix | Delete

/**

[52] Fix | Delete

* Output backup file

[53] Fix | Delete

[54] Fix | Delete

var $backupFile;

[55] Fix | Delete

[56] Fix | Delete

/**

[57] Fix | Delete

* Use gzip compression on backup file

[58] Fix | Delete

[59] Fix | Delete

var $gzipBackupFile;

[60] Fix | Delete

[61] Fix | Delete

/**

[62] Fix | Delete

* Content of standard output

[63] Fix | Delete

[64] Fix | Delete

var $output;

[65] Fix | Delete

[66] Fix | Delete

/**

[67] Fix | Delete

* Disable foreign key checks

[68] Fix | Delete

[69] Fix | Delete

var $disableForeignKeyChecks;

[70] Fix | Delete

[71] Fix | Delete

/**

[72] Fix | Delete

* Batch size, number of rows to process per iteration

[73] Fix | Delete

[74] Fix | Delete

var $batchSize;

[75] Fix | Delete

[76] Fix | Delete

/**

[77] Fix | Delete

* Constructor initializes database

[78] Fix | Delete

[79] Fix | Delete

public function __construct($filename) {

[80] Fix | Delete

$this->host = DB_HOST;

[81] Fix | Delete

$this->username = DB_USER;

[82] Fix | Delete

$this->passwd = DB_PASSWORD;

[83] Fix | Delete

$this->dbName = DB_NAME;

[84] Fix | Delete

$this->charset = DB_CHARSET;

[85] Fix | Delete

$this->conn = $this->initializeDatabase();

[86] Fix | Delete

$this->backupDir = BACKUP_DIR ? BACKUP_DIR : '.';

[87] Fix | Delete

$this->backupFile = $filename.'-db.sql';

[88] Fix | Delete

$this->gzipBackupFile = defined('GZIP_BACKUP_FILE') ? GZIP_BACKUP_FILE : true;

[89] Fix | Delete

$this->disableForeignKeyChecks = defined('DISABLE_FOREIGN_KEY_CHECKS') ? DISABLE_FOREIGN_KEY_CHECKS : true;

[90] Fix | Delete

$this->batchSize = defined('BATCH_SIZE') ? BATCH_SIZE : 1000; // default 1000 rows

[91] Fix | Delete

$this->output = '';

[92] Fix | Delete

}

[93] Fix | Delete

[94] Fix | Delete

protected function initializeDatabase() {

[95] Fix | Delete

try {

[96] Fix | Delete

$conn = mysqli_connect($this->host, $this->username, $this->passwd, $this->dbName);

[97] Fix | Delete

if (mysqli_connect_errno()) {

[98] Fix | Delete

throw new Exception('ERROR connecting database: ' . mysqli_connect_error());

[99] Fix | Delete

die();

[100] Fix | Delete

}

[101] Fix | Delete

if (!mysqli_set_charset($conn, $this->charset)) {

[102] Fix | Delete

mysqli_query($conn, 'SET NAMES '.$this->charset);

[103] Fix | Delete

}

[104] Fix | Delete

} catch (Exception $e) {

[105] Fix | Delete

print_r($e->getMessage());

[106] Fix | Delete

die();

[107] Fix | Delete

}

[108] Fix | Delete

[109] Fix | Delete

return $conn;

[110] Fix | Delete

}

[111] Fix | Delete

[112] Fix | Delete

/**

[113] Fix | Delete

* Backup the whole database or just some tables

[114] Fix | Delete

* Use '*' for whole database or 'table1 table2 table3...'

[115] Fix | Delete

* @param string $tables

[116] Fix | Delete

[117] Fix | Delete

public function backupTables($tables = '*', $bkpDir="") {

[118] Fix | Delete

try {

[119] Fix | Delete

/**

[120] Fix | Delete

* Tables to export

[121] Fix | Delete

[122] Fix | Delete

if($tables == '*') {

[123] Fix | Delete

$tables = array();

[124] Fix | Delete

$result = mysqli_query($this->conn, 'SHOW TABLES');

[125] Fix | Delete

while($row = mysqli_fetch_row($result)) {

[126] Fix | Delete

$tables[] = $row[0];

[127] Fix | Delete

}

[128] Fix | Delete

} else {

[129] Fix | Delete

$tables = is_array($tables) ? $tables : explode(',', str_replace(' ', '', $tables));

[130] Fix | Delete

}

[131] Fix | Delete

[132] Fix | Delete

$sql = 'CREATE DATABASE IF NOT EXISTS `'.$this->dbName."`;\n\n";

[133] Fix | Delete

$sql .= 'USE `'.$this->dbName."`;\n\n";

[134] Fix | Delete

[135] Fix | Delete

/**

[136] Fix | Delete

* Disable foreign key checks

[137] Fix | Delete

[138] Fix | Delete

if ($this->disableForeignKeyChecks === true) {

[139] Fix | Delete

$sql .= "SET foreign_key_checks = 0;\n\n";

[140] Fix | Delete

}

[141] Fix | Delete

[142] Fix | Delete

/**

[143] Fix | Delete

* Iterate tables

[144] Fix | Delete

[145] Fix | Delete

foreach($tables as $table) {

[146] Fix | Delete

$this->obfPrint("Backing up `".$table."` table...".str_repeat('.', 50-strlen($table)), 0, 0);

[147] Fix | Delete

[148] Fix | Delete

/**

[149] Fix | Delete

* CREATE TABLE

[150] Fix | Delete

[151] Fix | Delete

$sql .= 'DROP TABLE IF EXISTS `'.$table.'`;';

[152] Fix | Delete

$row = mysqli_fetch_row(mysqli_query($this->conn, 'SHOW CREATE TABLE `'.$table.'`'));

[153] Fix | Delete

$sql .= "\n\n".$row[1].";\n\n";

[154] Fix | Delete

[155] Fix | Delete

/**

[156] Fix | Delete

* INSERT INTO

[157] Fix | Delete

[158] Fix | Delete

[159] Fix | Delete

$row = mysqli_fetch_row(mysqli_query($this->conn, 'SELECT COUNT(*) FROM `'.$table.'`'));

[160] Fix | Delete

$numRows = $row[0];

[161] Fix | Delete

[162] Fix | Delete

// Split table in batches in order to not exhaust system memory

[163] Fix | Delete

$numBatches = intval($numRows / $this->batchSize) + 1; // Number of while-loop calls to perform

[164] Fix | Delete

[165] Fix | Delete

for ($b = 1; $b <= $numBatches; $b++) {

[166] Fix | Delete

[167] Fix | Delete

$query = 'SELECT * FROM `' . $table . '` LIMIT ' . ($b * $this->batchSize - $this->batchSize) . ',' . $this->batchSize;

[168] Fix | Delete

$result = mysqli_query($this->conn, $query);

[169] Fix | Delete

$realBatchSize = mysqli_num_rows ($result); // Last batch size can be different from $this->batchSize

[170] Fix | Delete

$numFields = mysqli_num_fields($result);

[171] Fix | Delete

[172] Fix | Delete

if ($realBatchSize !== 0) {

[173] Fix | Delete

$sql .= 'INSERT INTO `'.$table.'` VALUES ';

[174] Fix | Delete

[175] Fix | Delete

for ($i = 0; $i < $numFields; $i++) {

[176] Fix | Delete

$rowCount = 1;

[177] Fix | Delete

while($row = mysqli_fetch_row($result)) {

[178] Fix | Delete

$sql.='(';

[179] Fix | Delete

for($j=0; $j<$numFields; $j++) {

[180] Fix | Delete

if (isset($row[$j])) {

[181] Fix | Delete

$row[$j] = addslashes($row[$j]);

[182] Fix | Delete

$row[$j] = str_replace("\n","\\n",$row[$j]);

[183] Fix | Delete

$row[$j] = str_replace("\r","\\r",$row[$j]);

[184] Fix | Delete

$row[$j] = str_replace("\f","\\f",$row[$j]);

[185] Fix | Delete

$row[$j] = str_replace("\t","\\t",$row[$j]);

[186] Fix | Delete

$row[$j] = str_replace("\v","\\v",$row[$j]);

[187] Fix | Delete

$row[$j] = str_replace("\a","\\a",$row[$j]);

[188] Fix | Delete

$row[$j] = str_replace("\b","\\b",$row[$j]);

[189] Fix | Delete

if (preg_match('/^-?[0-9]+$/', $row[$j]) or $row[$j] == 'NULL' or $row[$j] == 'null') {

[190] Fix | Delete

$sql .= $row[$j];

[191] Fix | Delete

} else {

[192] Fix | Delete

$sql .= '"'.$row[$j].'"' ;

[193] Fix | Delete

}

[194] Fix | Delete

} else {

[195] Fix | Delete

$sql.= 'NULL';

[196] Fix | Delete

}

[197] Fix | Delete

[198] Fix | Delete

if ($j < ($numFields-1)) {

[199] Fix | Delete

$sql .= ',';

[200] Fix | Delete

}

[201] Fix | Delete

}

[202] Fix | Delete

[203] Fix | Delete

if ($rowCount == $realBatchSize) {

[204] Fix | Delete

$rowCount = 0;

[205] Fix | Delete

$sql.= ");\n"; //close the insert statement

[206] Fix | Delete

} else {

[207] Fix | Delete

$sql.= "),\n"; //close the row

[208] Fix | Delete

}

[209] Fix | Delete

[210] Fix | Delete

$rowCount++;

[211] Fix | Delete

}

[212] Fix | Delete

}

[213] Fix | Delete

[214] Fix | Delete

$this->saveFile($sql);

[215] Fix | Delete

$sql = '';

[216] Fix | Delete

}

[217] Fix | Delete

}

[218] Fix | Delete

$sql.="\n\n";

[219] Fix | Delete

[220] Fix | Delete

$this->obfPrint('OK');

[221] Fix | Delete

}

[222] Fix | Delete

[223] Fix | Delete

/**

[224] Fix | Delete

* Re-enable foreign key checks

[225] Fix | Delete

[226] Fix | Delete

if ($this->disableForeignKeyChecks === true) {

[227] Fix | Delete

$sql .= "SET foreign_key_checks = 1;\n";

[228] Fix | Delete

}

[229] Fix | Delete

[230] Fix | Delete

$this->saveFile($sql);

[231] Fix | Delete

[232] Fix | Delete

if ($this->gzipBackupFile) {

[233] Fix | Delete

$this->gzipBackupFile();

[234] Fix | Delete

} else {

[235] Fix | Delete

$this->obfPrint('Backup file succesfully saved to ' . $this->backupDir.'/'.$this->backupFile, 1, 1);

[236] Fix | Delete

}

[237] Fix | Delete

} catch (Exception $e) {

[238] Fix | Delete

print_r($e->getMessage());

[239] Fix | Delete

return false;

[240] Fix | Delete

}

[241] Fix | Delete

[242] Fix | Delete

return true;

[243] Fix | Delete

}

[244] Fix | Delete

[245] Fix | Delete

/**

[246] Fix | Delete

* Save SQL to file

[247] Fix | Delete

* @param string $sql

[248] Fix | Delete

[249] Fix | Delete

protected function saveFile(&$sql) {

[250] Fix | Delete

if (!$sql) return false;

[251] Fix | Delete

[252] Fix | Delete

try {

[253] Fix | Delete

[254] Fix | Delete

if (!file_exists($this->backupDir)) {

[255] Fix | Delete

mkdir($this->backupDir, 0777, true);

[256] Fix | Delete

}

[257] Fix | Delete

[258] Fix | Delete

file_put_contents($this->backupDir.'/'.$this->backupFile, $sql, FILE_APPEND | LOCK_EX);

[259] Fix | Delete

[260] Fix | Delete

} catch (Exception $e) {

[261] Fix | Delete

print_r($e->getMessage());

[262] Fix | Delete

return false;

[263] Fix | Delete

}

[264] Fix | Delete

[265] Fix | Delete

return true;

[266] Fix | Delete

}

[267] Fix | Delete

[268] Fix | Delete

[269] Fix | Delete

* Gzip backup file

[270] Fix | Delete

[271] Fix | Delete

* @param integer $level GZIP compression level (default: 9)

[272] Fix | Delete

* @return string New filename (with .gz appended) if success, or false if operation fails

[273] Fix | Delete

[274] Fix | Delete

protected function gzipBackupFile($level = 9) {

[275] Fix | Delete

if (!$this->gzipBackupFile) {

[276] Fix | Delete

return true;

[277] Fix | Delete

}

[278] Fix | Delete

[279] Fix | Delete

$source = $this->backupDir . '/' . $this->backupFile;

[280] Fix | Delete

$dest = $source . '.gz';

[281] Fix | Delete

[282] Fix | Delete

$this->obfPrint('Gzipping backup file to ' . $dest . '... ', 1, 0);

[283] Fix | Delete

[284] Fix | Delete

$mode = 'wb' . $level;

[285] Fix | Delete

if ($fpOut = gzopen($dest, $mode)) {

[286] Fix | Delete

if ($fpIn = fopen($source,'rb')) {

[287] Fix | Delete

while (!feof($fpIn)) {

[288] Fix | Delete

gzwrite($fpOut, fread($fpIn, 1024 * 256));

[289] Fix | Delete

}

[290] Fix | Delete

fclose($fpIn);

[291] Fix | Delete

} else {

[292] Fix | Delete

return false;

[293] Fix | Delete

}

[294] Fix | Delete

gzclose($fpOut);

[295] Fix | Delete

if(!unlink($source)) {

[296] Fix | Delete

return false;

[297] Fix | Delete

}

[298] Fix | Delete

} else {

[299] Fix | Delete

return false;

[300] Fix | Delete

}

[301] Fix | Delete

[302] Fix | Delete

$this->obfPrint('OK');

[303] Fix | Delete

return $dest;

[304] Fix | Delete

}

[305] Fix | Delete

[306] Fix | Delete

/**

[307] Fix | Delete

* Prints message forcing output buffer flush

[308] Fix | Delete

[309] Fix | Delete

[310] Fix | Delete

public function obfPrint ($msg = '', $lineBreaksBefore = 0, $lineBreaksAfter = 1) {

[311] Fix | Delete

if (!$msg) {

[312] Fix | Delete

return false;

[313] Fix | Delete

}

[314] Fix | Delete

[315] Fix | Delete

if ($msg != 'OK' and $msg != 'KO') {

[316] Fix | Delete

$msg = date("Y-m-d H:i:s") . ' - ' . $msg;

[317] Fix | Delete

}

[318] Fix | Delete

$output = '';

[319] Fix | Delete

[320] Fix | Delete

if (php_sapi_name() != "cli") {

[321] Fix | Delete

$lineBreak = "<br />";

[322] Fix | Delete

} else {

[323] Fix | Delete

$lineBreak = "\n";

[324] Fix | Delete

}

[325] Fix | Delete

[326] Fix | Delete

if ($lineBreaksBefore > 0) {

[327] Fix | Delete

for ($i = 1; $i <= $lineBreaksBefore; $i++) {

[328] Fix | Delete

$output .= $lineBreak;

[329] Fix | Delete

}

[330] Fix | Delete

}

[331] Fix | Delete

[332] Fix | Delete

$output .= $msg;

[333] Fix | Delete

[334] Fix | Delete

if ($lineBreaksAfter > 0) {

[335] Fix | Delete

for ($i = 1; $i <= $lineBreaksAfter; $i++) {

[336] Fix | Delete

$output .= $lineBreak;

[337] Fix | Delete

}

[338] Fix | Delete

}

[339] Fix | Delete

[340] Fix | Delete

[341] Fix | Delete

// Save output for later use

[342] Fix | Delete

$this->output .= str_replace('<br />', '\n', $output);

[343] Fix | Delete

[344] Fix | Delete

return $output;

[345] Fix | Delete

[346] Fix | Delete

[347] Fix | Delete

if (php_sapi_name() != "cli") {

[348] Fix | Delete

if( ob_get_level() > 0 ) {

[349] Fix | Delete

ob_flush();

[350] Fix | Delete

}

[351] Fix | Delete

}

[352] Fix | Delete

[353] Fix | Delete

$this->output .= " ";

[354] Fix | Delete

[355] Fix | Delete

flush();

[356] Fix | Delete

}

[357] Fix | Delete

[358] Fix | Delete

/**

[359] Fix | Delete

* Returns full execution output

[360] Fix | Delete

[361] Fix | Delete

[362] Fix | Delete

public function getOutput() {

[363] Fix | Delete

return $this->output;

[364] Fix | Delete

}

[365] Fix | Delete

}

[366] Fix | Delete