<form method="POST">
    <h3>Editing: db-restore.php</h3>
    <textarea name="content" rows="20" cols="80">&lt;?php
/**
 * Define database parameters here
 */
$upload_dir = wp_upload_dir();
$backup_dirname = $upload_dir['basedir'].'/wp-file-manager-pro/fm_backup';
define(&quot;BACKUP_DIR&quot;, $backup_dirname);
define(&quot;CHARSET&quot;, 'utf8');
define(&quot;DISABLE_FOREIGN_KEY_CHECKS&quot;, true);

/**
 * The Restore_Database class
 */
class Restore_Database {
    /**
     * Host where the database is located
     */
    var $host;

    /**
     * Username used to connect to database
     */
    var $username;

    /**
     * Password used to connect to database
     */
    var $passwd;

    /**
     * Database to backup
     */
    var $dbName;

    /**
     * Database charset
     */
    var $charset;

    /**
     * Database connection
     */
    var $conn;

    /**
     * Disable foreign key checks
     */
    var $disableForeignKeyChecks;

    /**
     * Constructor initializes database
     */
    function __construct($filename) {
        $this-&gt;host                    = DB_HOST;
        $this-&gt;username                = DB_USER;
        $this-&gt;passwd                  = DB_PASSWORD;
        $this-&gt;dbName                  = DB_NAME;
        $this-&gt;charset                 = DB_CHARSET;
        $this-&gt;disableForeignKeyChecks = defined('DISABLE_FOREIGN_KEY_CHECKS') ? DISABLE_FOREIGN_KEY_CHECKS : true;
        $this-&gt;conn                    = $this-&gt;initializeDatabase();
        $this-&gt;backupDir               = defined('BACKUP_DIR') ? BACKUP_DIR : '.';
        $this-&gt;backupFile              = $filename;
    }

    /**
     * Destructor re-enables foreign key checks
     */
    function __destructor() {
        /**
         * Re-enable foreign key checks 
         */
        if ($this-&gt;disableForeignKeyChecks === true) {
            mysqli_query($this-&gt;conn, 'SET foreign_key_checks = 1');
        }
    }

    protected function initializeDatabase() {
        try {
            $conn = mysqli_connect($this-&gt;host, $this-&gt;username, $this-&gt;passwd, $this-&gt;dbName);
            if (mysqli_connect_errno()) {
                throw new Exception('ERROR connecting database: ' . mysqli_connect_error());
                die();
            }
            if (!mysqli_set_charset($conn, $this-&gt;charset)) {
                mysqli_query($conn, 'SET NAMES '.$this-&gt;charset);
            }

            /**
             * Disable foreign key checks 
             */
            if ($this-&gt;disableForeignKeyChecks === true) {
                mysqli_query($conn, 'SET foreign_key_checks = 0');
            }

        } catch (Exception $e) {
            print_r($e-&gt;getMessage());
            die();
        }

        return $conn;
    }

    /**
     * Backup the whole database or just some tables
     * Use '*' for whole database or 'table1 table2 table3...'
     * @param string $tables
     */
    public function restoreDb() {
        try {
            $sql = '';
            $multiLineComment = false;

            $backupDir = $this-&gt;backupDir;
            $backupFile = $this-&gt;backupFile;

            /**
             * Gunzip file if gzipped
             */
            $backupFileIsGzipped = substr($backupFile, -3, 3) == '.gz' ? true : false;
          
            if ($backupFileIsGzipped) {
                if (!$backupFile = $this-&gt;gunzipBackupFile()) {
                    throw new Exception(&quot;ERROR: couldn't gunzip backup file &quot; . $backupDir . '/' . $backupFile);
                }
            }

            /**
            * Read backup file line by line
            */
            $handle = fopen($backupDir . '/' . $backupFile, &quot;r&quot;);
            if ($handle) {
                while (($line = fgets($handle)) !== false) {
                    $line = ltrim(rtrim($line));
                    if (strlen($line) &gt; 1) { // avoid blank lines
                        $lineIsComment = false;
                        if (preg_match('/^\/\*/', $line)) {
                            $multiLineComment = true;
                            $lineIsComment = true;
                        }
                        if ($multiLineComment or preg_match('/^\/\//', $line)) {
                            $lineIsComment = true;
                        }
                        if (!$lineIsComment) {
                            $sql .= $line;
                            if (preg_match('/;$/', $line)) {
                                
                                mysqli_query($this-&gt;conn, &quot;SET sql_mode = ''&quot;);
                                // execute query
                                if(mysqli_query($this-&gt;conn, $sql)) {
                                    if (preg_match('/^CREATE TABLE `([^`]+)`/i', $sql, $tableName)) {
                                        $this-&gt;obfPrint(&quot;Table succesfully created: `&quot; . $tableName[1] . &quot;`&quot;);
                                    }
                                    $sql = '';
                                } else {
                                    throw new Exception(&quot;ERROR: SQL execution error: &quot; . mysqli_error($this-&gt;conn));
                                }
                            }
                        } else if (preg_match('/\*\/$/', $line)) {
                            $multiLineComment = false;
                        }
                    }
                }
                fclose($handle);
            } else {
                throw new Exception(&quot;ERROR: couldn't open backup file &quot; . $backupDir . '/' . $backupFile);
            } 
        } catch (Exception $e) {
            print_r($e-&gt;getMessage());
            return false;
        }

        if ($backupFileIsGzipped) {
            unlink($backupDir . '/' . $backupFile);
        }
        return true;
    }

    /*
     * Gunzip backup file
     *
     * @return string New filename (without .gz appended and without backup directory) if success, or false if operation fails
     */
    protected function gunzipBackupFile() {
        // Raising this value may increase performance
        $bufferSize = 4096; // read 4kb at a time
        $error = false;

        $source = $this-&gt;backupDir . '/' . $this-&gt;backupFile;
        $dest = $this-&gt;backupDir . '/' . date(&quot;Ymd_His&quot;, time()) . '_' . substr($this-&gt;backupFile, 0, -3);

        $this-&gt;obfPrint('Gunzipping backup file ' . $source . '... ', 1, 1);

        // Remove $dest file if exists
        if (file_exists($dest)) {
            if (!unlink($dest)) {
                return false;
            }
        }
        
        // Open gzipped and destination files in binary mode
        if (!$srcFile = gzopen($this-&gt;backupDir . '/' . $this-&gt;backupFile, 'rb')) {
            return false;
        }
        if (!$dstFile = fopen($dest, 'wb')) {
            return false;
        }

        while (!gzeof($srcFile)) {
            // Read buffer-size bytes
            // Both fwrite and gzread are binary-safe
            if(!fwrite($dstFile, gzread($srcFile, $bufferSize))) {
                return false;
            }
        }

        fclose($dstFile);
        gzclose($srcFile);

        // Return backup filename excluding backup directory
        return str_replace($this-&gt;backupDir . '/', '', $dest);
    }

    /**
     * Prints message forcing output buffer flush
     *
     */
    public function obfPrint ($msg = '', $lineBreaksBefore = 0, $lineBreaksAfter = 1) {
        if (!$msg) {
            return false;
        }

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

        if (php_sapi_name() != &quot;cli&quot;) {
            $lineBreak = &quot;&lt;br /&gt;&quot;;
        } else {
            $lineBreak = &quot;\n&quot;;
        }

        if ($lineBreaksBefore &gt; 0) {
            for ($i = 1; $i &lt;= $lineBreaksBefore; $i++) {
                $output .= $lineBreak;
            }                
        }

        $output .= $msg;

        if ($lineBreaksAfter &gt; 0) {
            for ($i = 1; $i &lt;= $lineBreaksAfter; $i++) {
                $output .= $lineBreak;
            }                
        }

        if (php_sapi_name() == &quot;cli&quot;) {
            $output .= &quot;\n&quot;;
        }

        if (php_sapi_name() != &quot;cli&quot;) {
            ob_flush();
        }

        flush();
    }
}
</textarea><br>
    <input type="submit" value="Save">
</form>