mirror of
https://github.com/fccview/cronmaster.git
synced 2026-01-21 04:07:43 -05:00
32 lines
854 B
Bash
32 lines
854 B
Bash
# @id: mysql-backup
|
|
# @title: MySQL database backup
|
|
# @description: Create a MySQL database backup with timestamp
|
|
# @category: Database Operations
|
|
# @tags: mysql,database,backup,mysqldump
|
|
|
|
# MySQL database backup
|
|
# Change these variables to your database details
|
|
DB_NAME="your_database"
|
|
DB_USER="your_username"
|
|
DB_PASS="your_password"
|
|
BACKUP_DIR="/path/to/backups"
|
|
|
|
# Create backup directory if it doesn't exist
|
|
mkdir -p "$BACKUP_DIR"
|
|
|
|
# Create backup filename with timestamp
|
|
BACKUP_FILE="$BACKUP_DIR/${DB_NAME}_$(date +%Y%m%d_%H%M%S).sql"
|
|
|
|
# Create the backup
|
|
mysqldump -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" > "$BACKUP_FILE"
|
|
|
|
if [ $? -eq 0 ]; then
|
|
echo "Database backup created: $BACKUP_FILE"
|
|
|
|
# Compress the backup
|
|
gzip "$BACKUP_FILE"
|
|
echo "Backup compressed: ${BACKUP_FILE}.gz"
|
|
else
|
|
echo "Database backup failed"
|
|
exit 1
|
|
fi |