Plugin for the RedBeanPHP ORM, which will create Backup files for a MySql DB Server.

mysqldump.php

<?php

declare(strict_types=1);

use RedBeanPHP\Facade as R;

//https://github.com/zewa666/RedBean_MysqlBackup
R::ext('mysqldump', function (string $file, int $step = 100) {
    if (!(R::getWriter() instanceof \RedBeanPHP\QueryWriter\MySQL)) {
        throw new Exception('This plugin only supports MySql.');
    }

    $buffer = '';

    foreach (R::inspect() as $table) {
        $buffer .= 'DROP TABLE '.$table.';'.PHP_EOL;
        $row = R::getRow('SHOW CREATE TABLE '.$table);
        $buffer .= $row['Create Table'].';'.PHP_EOL;

        $fields = R::inspect($table);

        $pdo = R::getPDO();
        $query = $pdo->prepare('SELECT * FROM '.$table);
        $query->execute();

        $n = 0;
        while ($row = $query->fetch()) {
            $parts = [];

            if (is_int($n / $step)) {
                if ($n > 0) {
                    $buffer .= ';'.PHP_EOL;
                }

                $buffer .= 'INSERT INTO '.$table.' VALUES';
            } else {
                $buffer .= ',';
            }

            $buffer .= ' (';

            foreach ($fields as $key => $field) {
                if (is_null($row[$key])) {
                    $parts[] = 'NULL';
                } else {
                    $parts[] = $pdo->quote((string) $row[$key]);
                }
            }

            $buffer .= implode(',', $parts).')';

            ++$n;
        }

        if ($n > 0) {
            $buffer .= ';';
        }

        $buffer .= PHP_EOL;
    }

    return file_put_contents($file, $buffer);
});