#!/bin/bash

# MySQL database details
DB_USER="root"
DB_PASS="XZW-@=kf#Jhvs7tB"
DB_NAME="bms_new_code"

# Backup directory
BACKUP_DIR="/home/databackup/dbbackup/"

# Timestamp for backup file
TIMESTAMP=$(date +"%Y%m%d_%H%M%S")

# Backup MySQL database
mysqldump -u $DB_USER -p$DB_PASS $DB_NAME > $BACKUP_DIR/db_backup_$TIMESTAMP.sql