76 lines · 2.5 KB · TypeScript
RawDownload
import type { BackupSchedule } from "@dokploy/server/services/backup";import {	createDeploymentBackup,	updateDeploymentStatus,} from "@dokploy/server/services/deployment";import { findDestinationById } from "@dokploy/server/services/destination";import { findEnvironmentById } from "@dokploy/server/services/environment";import type { MySql } from "@dokploy/server/services/mysql";import { findProjectById } from "@dokploy/server/services/project";import { sendDatabaseBackupNotifications } from "../notifications/database-backup";import { execAsync, execAsyncRemote } from "../process/execAsync";import {	getBackupCommand,	getBackupTimestamp,	getS3Credentials,	normalizeS3Path,} from "./utils"; export const runMySqlBackup = async (mysql: MySql, backup: BackupSchedule) => {	const { environmentId, name, appName } = mysql;	const environment = await findEnvironmentById(environmentId);	const project = await findProjectById(environment.projectId);	const { prefix } = backup;	const destination = await findDestinationById(backup.destinationId);	const backupFileName = `${getBackupTimestamp()}.sql.gz`;	const bucketDestination = `${appName}/${normalizeS3Path(prefix)}${backupFileName}`;	const deployment = await createDeploymentBackup({		backupId: backup.backupId,		title: "MySQL Backup",		description: "MySQL Backup",	}); 	try {		const rcloneFlags = getS3Credentials(destination);		const rcloneDestination = `:s3:${destination.bucket}/${bucketDestination}`; 		const rcloneCommand = `rclone rcat ${rcloneFlags.join(" ")} "${rcloneDestination}"`; 		const backupCommand = getBackupCommand(			backup,			rcloneCommand,			deployment.logPath,		); 		if (mysql.serverId) {			await execAsyncRemote(mysql.serverId, backupCommand);		} else {			await execAsync(backupCommand, {				shell: "/bin/bash",			});		}		await sendDatabaseBackupNotifications({			applicationName: name,			projectName: project.name,			databaseType: "mysql",			type: "success",			organizationId: project.organizationId,			databaseName: backup.database,		});		await updateDeploymentStatus(deployment.deploymentId, "done");	} catch (error) {		console.log(error);		await sendDatabaseBackupNotifications({			applicationName: name,			projectName: project.name,			databaseType: "mysql",			type: "error",			// @ts-ignore			errorMessage: error?.message || "Error message not provided",			organizationId: project.organizationId,			databaseName: backup.database,		});		await updateDeploymentStatus(deployment.deploymentId, "error");		throw error;	}};

Keyboard shortcuts

General

Show keyboard shortcuts
?
Focus the current search
/

Issues and pull requests

Open filters
f

Issues, pull requests and Inbox

Select next item
j↓
Select previous item
k↑
Open selected item
Enter
Dismiss filters or clear selection
Esc

Repository code

Go to file
t