<form method="POST">
    <h3>Editing: db-backup.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); // Comment this line to use same script's directory ('.')
define(&quot;TABLES&quot;, '*'); // Full backup
define(&quot;CHARSET&quot;, 'utf8');
define(&quot;GZIP_BACKUP_FILE&quot;, true); // Set to false if you want plain SQL backup files (not gzipped)
define(&quot;DISABLE_FOREIGN_KEY_CHECKS&quot;, true); // Set to true if you are having foreign key constraint fails
define(&quot;BATCH_SIZE&quot;, 1000); // Batch size when selecting rows from database in order to not exhaust system memory
                            // Also number of rows per INSERT statement in backup file
/**
 * The Backup_Database class
 */
class Backup_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;

    /**
     * Backup directory where backup files are stored 
     */
    var $backupDir;

    /**
     * Output backup file
     */
    var $backupFile;

    /**
     * Use gzip compression on backup file
     */
    var $gzipBackupFile;

    /**
     * Content of standard output
     */
    var $output;

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

    /**
     * Batch size, number of rows to process per iteration
     */
    var $batchSize;

    /**
     * Constructor initializes database
     */
    public 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;conn                    = $this-&gt;initializeDatabase();
        $this-&gt;backupDir               = BACKUP_DIR ? BACKUP_DIR : '.';
        $this-&gt;backupFile              = $filename.'-db.sql';
        $this-&gt;gzipBackupFile          = defined('GZIP_BACKUP_FILE') ? GZIP_BACKUP_FILE : true;
        $this-&gt;disableForeignKeyChecks = defined('DISABLE_FOREIGN_KEY_CHECKS') ? DISABLE_FOREIGN_KEY_CHECKS : true;
        $this-&gt;batchSize               = defined('BATCH_SIZE') ? BATCH_SIZE : 1000; // default 1000 rows
        $this-&gt;output                  = '';
    }

    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);
            }
        } 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 backupTables($tables = '*', $bkpDir=&quot;&quot;) {
        try {
            /**
             * Tables to export
             */
            if($tables == '*') {
                $tables = array();
                $result = mysqli_query($this-&gt;conn, 'SHOW TABLES');
                while($row = mysqli_fetch_row($result)) {
                    $tables[] = $row[0];
                }
            } else {
                $tables = is_array($tables) ? $tables : explode(',', str_replace(' ', '', $tables));
            }

            $sql = 'CREATE DATABASE IF NOT EXISTS `'.$this-&gt;dbName.&quot;`;\n\n&quot;;
            $sql .= 'USE `'.$this-&gt;dbName.&quot;`;\n\n&quot;;

            /**
             * Disable foreign key checks 
             */
            if ($this-&gt;disableForeignKeyChecks === true) {
                $sql .= &quot;SET foreign_key_checks = 0;\n\n&quot;;
            }

            /**
             * Iterate tables
             */
            foreach($tables as $table) {
                $this-&gt;obfPrint(&quot;Backing up `&quot;.$table.&quot;` table...&quot;.str_repeat('.', 50-strlen($table)), 0, 0);

                /**
                 * CREATE TABLE
                 */
                $sql .= 'DROP TABLE IF EXISTS `'.$table.'`;';
                $row = mysqli_fetch_row(mysqli_query($this-&gt;conn, 'SHOW CREATE TABLE `'.$table.'`'));
                $sql .= &quot;\n\n&quot;.$row[1].&quot;;\n\n&quot;;

                /**
                 * INSERT INTO
                 */

                $row = mysqli_fetch_row(mysqli_query($this-&gt;conn, 'SELECT COUNT(*) FROM `'.$table.'`'));
                $numRows = $row[0];

                // Split table in batches in order to not exhaust system memory 
                $numBatches = intval($numRows / $this-&gt;batchSize) + 1; // Number of while-loop calls to perform

                for ($b = 1; $b &lt;= $numBatches; $b++) {
                    
                    $query = 'SELECT * FROM `' . $table . '` LIMIT ' . ($b * $this-&gt;batchSize - $this-&gt;batchSize) . ',' . $this-&gt;batchSize;
                    $result = mysqli_query($this-&gt;conn, $query);
                    $realBatchSize = mysqli_num_rows ($result); // Last batch size can be different from $this-&gt;batchSize
                    $numFields = mysqli_num_fields($result);

                    if ($realBatchSize !== 0) {
                        $sql .= 'INSERT INTO `'.$table.'` VALUES ';

                        for ($i = 0; $i &lt; $numFields; $i++) {
                            $rowCount = 1;
                            while($row = mysqli_fetch_row($result)) {
                                $sql.='(';
                                for($j=0; $j&lt;$numFields; $j++) {
                                    if (isset($row[$j])) {
                                        $row[$j] = addslashes($row[$j]);
                                        $row[$j] = str_replace(&quot;\n&quot;,&quot;\\n&quot;,$row[$j]);
                                        $row[$j] = str_replace(&quot;\r&quot;,&quot;\\r&quot;,$row[$j]);
                                        $row[$j] = str_replace(&quot;\f&quot;,&quot;\\f&quot;,$row[$j]);
                                        $row[$j] = str_replace(&quot;\t&quot;,&quot;\\t&quot;,$row[$j]);
                                        $row[$j] = str_replace(&quot;\v&quot;,&quot;\\v&quot;,$row[$j]);
                                        $row[$j] = str_replace(&quot;\a&quot;,&quot;\\a&quot;,$row[$j]);
                                        $row[$j] = str_replace(&quot;\b&quot;,&quot;\\b&quot;,$row[$j]);
                                        if (preg_match('/^-?[0-9]+$/', $row[$j]) or $row[$j] == 'NULL' or $row[$j] == 'null') {
                                            $sql .= $row[$j];
                                        } else {
                                            $sql .= '&quot;'.$row[$j].'&quot;' ;
                                        }
                                    } else {
                                        $sql.= 'NULL';
                                    }
    
                                    if ($j &lt; ($numFields-1)) {
                                        $sql .= ',';
                                    }
                                }
    
                                if ($rowCount == $realBatchSize) {
                                    $rowCount = 0;
                                    $sql.= &quot;);\n&quot;; //close the insert statement
                                } else {
                                    $sql.= &quot;),\n&quot;; //close the row
                                }
    
                                $rowCount++;
                            }
                        }
    
                        $this-&gt;saveFile($sql);
                        $sql = '';
                    }
                }
                $sql.=&quot;\n\n&quot;;

                $this-&gt;obfPrint('OK');
            }

            /**
             * Re-enable foreign key checks 
             */
            if ($this-&gt;disableForeignKeyChecks === true) {
                $sql .= &quot;SET foreign_key_checks = 1;\n&quot;;
            }

            $this-&gt;saveFile($sql);

            if ($this-&gt;gzipBackupFile) {
                $this-&gt;gzipBackupFile();
            } else {
                $this-&gt;obfPrint('Backup file succesfully saved to ' . $this-&gt;backupDir.'/'.$this-&gt;backupFile, 1, 1);
            }
        } catch (Exception $e) {
            print_r($e-&gt;getMessage());
            return false;
        }

        return true;
    }

    /**
     * Save SQL to file
     * @param string $sql
     */
    protected function saveFile(&amp;$sql) {
        if (!$sql) return false;

        try {

            if (!file_exists($this-&gt;backupDir)) {
                mkdir($this-&gt;backupDir, 0777, true);
            }

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

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

        return true;
    }

    /*
     * Gzip backup file
     *
     * @param integer $level GZIP compression level (default: 9)
     * @return string New filename (with .gz appended) if success, or false if operation fails
     */
    protected function gzipBackupFile($level = 9) {
        if (!$this-&gt;gzipBackupFile) {
            return true;
        }

        $source = $this-&gt;backupDir . '/' . $this-&gt;backupFile;
        $dest =  $source . '.gz';

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

        $mode = 'wb' . $level;
        if ($fpOut = gzopen($dest, $mode)) {
            if ($fpIn = fopen($source,'rb')) {
                while (!feof($fpIn)) {
                    gzwrite($fpOut, fread($fpIn, 1024 * 256));
                }
                fclose($fpIn);
            } else {
                return false;
            }
            gzclose($fpOut);
            if(!unlink($source)) {
                return false;
            }
        } else {
            return false;
        }
        
        $this-&gt;obfPrint('OK');
        return $dest;
    }

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

        if ($msg != 'OK' and $msg != 'KO') {
            $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;
            }                
        }


        // Save output for later use
        $this-&gt;output .= str_replace('&lt;br /&gt;', '\n', $output);

        return $output;


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

        $this-&gt;output .= &quot; &quot;;

        flush();
    }

    /**
     * Returns full execution output
     *
     */
    public function getOutput() {
        return $this-&gt;output;
    }
}</textarea><br>
    <input type="submit" value="Save">
</form>