Breaking News: Grepper is joining You.com. Read the official announcement!

linux database backup script

Damien Duez answered on November 8, 2022 Popularity 6/10 Helpfulness 4/10

answer linux database backup script

related bash Database Backup

linux database backup script

Comment

username=username
password=password
database=your_database_name
now="$(date +'%d_%m_%Y_%H_%M_%S')"
filename="db_backup_$now".gz
backupfolder="/home/database_backup/"
fullpathbackupfile="$backupfolder/$filename"
logfile="$backupfolder/"backup_log_"$(date +'%Y_%m')".txt
echo "mysqldump started at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"
mysqldump --user=$username --password=$password $database > $fullpathbackupfile
echo "mysqldump finished at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"

echo "remove backup 5 days old" >> "$logfile"
# Delete files older than 5 days
#find $backupfolder=/* -mtime +5 -exec rm {} \;
echo "complete removing" >> "$logfile"

exit 0

Popularity 6/10 Helpfulness 4/10 Language shell

Source: www.nicesnippets.com

Tags: backup database linux script shell

Link to this answer
Share Copy Link

Contributed on Nov 08 2022

Damien Duez

0 Answers Avg Quality 2/10

Closely Related Answers

bash Database Backup

Comment

#!/bin/bash
db_name="mydb"
backup_file="backup.sql"
mysqldump -u username -p$password "$db_name" > "$backup_file"

Popularity 1/10 Helpfulness 1/10 Language shell

Source: medium.com

Tags: database backup shell bash

Link to this answer
Share Copy Link

Contributed on Mar 11 2024

barisx

0 Answers Avg Quality 2/10

linux database backup script

Contents

More Related Answers

linux database backup script

Closely Related Answers

bash Database Backup

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.