'c:\\xampp\\mysql\\bin\\', // default
];
if (file_exists($config_file)) {
$saved = json_decode(file_get_contents($config_file), true);
if (is_array($saved)) {
$config = array_merge($config, $saved);
}
}
// -------- Handle "Save Settings" --------
$message = '';
$messageType = '';
if ($_SERVER['REQUEST_METHOD'] === 'POST' && ($_POST['action'] ?? '') === 'save_settings') {
$newPath = trim($_POST['mysqldump_path'] ?? '');
if ($newPath !== '') {
// Ensure trailing slash
if (!preg_match('#[\\\\/]$#', $newPath)) {
$newPath .= DIRECTORY_SEPARATOR;
}
$config['mysqldump_path'] = $newPath;
file_put_contents($config_file, json_encode($config, JSON_PRETTY_PRINT));
$message = "Settings saved.";
$messageType = 'success';
} else {
$message = "Path cannot be empty.";
$messageType = 'error';
}
}
// Build full mysqldump executable path
$mysqldump_exe = rtrim($config['mysqldump_path'], '\\/') . DIRECTORY_SEPARATOR . 'mysqldump.exe';
// -------- Handle Backup Action --------
if ($_SERVER['REQUEST_METHOD'] === 'POST' && in_array($_POST['action'] ?? '', ['backup_one', 'backup_all'])) {
$action = $_POST['action'];
$date = date('Ymd');
$mysqli = new mysqli($db_host, $db_user, $db_pass, '', $db_port);
if ($mysqli->connect_errno) {
$message = "Connection failed: " . $mysqli->connect_error;
$messageType = 'error';
} else {
$targets = [];
if ($action === 'backup_all') {
$res = $mysqli->query("SHOW DATABASES");
while ($row = $res->fetch_row()) {
$db = $row[0];
if (in_array($db, ['information_schema', 'performance_schema', 'mysql', 'sys', 'test'])) {
continue;
}
$targets[] = $db;
}
} elseif ($action === 'backup_one' && !empty($_POST['db_name'])) {
$targets[] = $_POST['db_name'];
}
$successCount = 0;
$errors = [];
foreach ($targets as $db) {
$filename = $db . '_' . $date . '.sql';
$filepath = $backup_dir . DIRECTORY_SEPARATOR . $filename;
$cmd = sprintf(
'%s --host=%s --port=%d --user=%s %s --result-file=%s %s 2>&1',
escapeshellarg($mysqldump_exe),
escapeshellarg($db_host),
(int)$db_port,
escapeshellarg($db_user),
$db_pass !== '' ? '--password=' . escapeshellarg($db_pass) : '',
escapeshellarg($filepath),
escapeshellarg($db)
);
$output = [];
$returnCode = 0;
exec($cmd, $output, $returnCode);
if ($returnCode === 0 && file_exists($filepath) && filesize($filepath) > 0) {
$successCount++;
} else {
$errors[] = $db . ' [exit=' . $returnCode . '] ' . implode(' ', $output);
}
}
if ($successCount > 0) {
$message = "Backup completed: $successCount database(s) saved to /backups ($date).";
$messageType = 'success';
}
if (!empty($errors)) {
$message .= " Errors: " . htmlspecialchars(implode('; ', $errors));
$messageType = 'error';
}
$mysqli->close();
}
}
// -------- Fetch Database List --------
$mysqli = new mysqli($db_host, $db_user, $db_pass, '', $db_port);
if ($mysqli->connect_errno) {
die("Connection failed: " . $mysqli->connect_error);
}
$result = $mysqli->query("SHOW DATABASES");
$databases = [];
while ($row = $result->fetch_row()) {
$db = $row[0];
if (in_array($db, ['information_schema', 'performance_schema', 'mysql', 'sys', 'test'])) {
continue;
}
$databases[] = $db;
}
$mysqli->close();
// Check if mysqldump exists
$mysqldump_exists = file_exists($mysqldump_exe);
?>
MySQL Databases & Backups
MySQL Databases
database(s) on
Databases
| # |
Database Name |
Backup File |
Action |
$db): ?>
|
|
_.sql |
|
Backups are saved to /backups as {db_name}_.sql