Backup Mysql Database to AWS S3 storage - Script

-

Hi ,

Below is the mysql backup script -  where you can backup it to the AWS S3 storage.

Add this script to the cron tab for automated backups daily.
 

#!/bin/bash
# Basic variables
mysqluser=" "
mysqlpass=" "
bucket="s3://bucket-name"
AWSPATH="/usr/local/bin/aws"

# Timestamp (sortable AND readable)
stamp=`date +"%s - %A %d %B %Y @ %H%M"`

# List all the databases
databases=`mysql -u$mysqluser -p$mysqlpass -e "SHOW DATABASES;" | tr -d "| " | grep -v "\(Database\|information_schema\|performance_schema\|mysql\|test\)"`

# Feedback
echo -e "Dumping to \e[1;32m$bucket/$stamp/\e[00m"

# Loop the databases
for db in $databases; do

# Define our filenames
filename="$stamp - $db.sql.gz"
tmpfile="/tmp/$filename"
object="$bucket/$stamp/$filename"

# Dump and zip
echo -e "  creating \e[0;35m$tmpfile\e[00m"
mysqldump -u$mysqluser -p$mysqlpass --force --opt --databases "$db" | gzip -c > "$tmpfile"

# Upload
echo -e "  uploading..."
 $AWSPATH s3 cp "$tmpfile" "$object"

# Delete
rm -f "$tmpfile"
done;

echo -e  "Jobs had a good run"


Please comment if you have any questions .


Comments

Post a Comment

Popular posts from this blog

Important GIT COMMANDS

-
Image
  1) Create a new repository git init Git command to init or create new repository  Executing this command creates a local repository with a default  main (or  master ) branch. To connect this local repository to Github, we need to create a remote repository on Github. And connect the remote repository’s origin with the local repository. git remote add origin https://github.com/ YOUR-USERNAME/YOUR-REPOSITORY Git command to add remote origin to the local repository  Finally, push the main branch on Github. git push -u REMOTE-NAME BRANCH-NAME Git command to push the local main branch  Note:   Execute all Git commands via terminal(Linux) or Git Bash(Windows) in the project working directory. 2) Make a new branch The gold standard for implementing a new feature is to create a new branch and put all the code in it. This keeps the existing code safe from bad implementation. git checkout -b NEW-BRANCH-NAME Git command to create a new branch  The checkout...
Read more

Docker Compose YML - Application , REDIS , MongoDB

-
Image
Software systems have become quite complex nowadays. A system may consist of several distributed services, each one providing a specific functionality and being updated independently. Starting the development of a project of such complexity is sometimes time consuming, in particular when you are not already familiar with the software stack you are going to work on. This may be because, most of the time, we need to follow rigorous steps to put together the entire project and if we make a mistake in-between, we may have to start all over again. Below is the YML file for redis, php & mongoDB :  The above yml file explains the 3 services which will create a virtual environment with 3 containers, ie Redis MongoDB Development Application You can write a DockerFile for the application development with nginx server.   The ports & volumes depends on your choices and how well you use it. Please comment on the blog, if you need any help.
Read more

Sendy Nginx Configuration

-
Hi , I have seen many people struggling of nginx configuration of the sendy application.  As the sendy application is not tested on the nginx and its rewrite rules, I have written the configuration and tested it.   I will add the configuration below here server {         listen 80 default_server;         listen [::]:80 default_server;         root /var/www/html; # Add index.php to the list if you are using PHP         index index.php index.html index.htm index.nginx-debian.html;         server_name (domain_name);    location / {                 # First attempt to serve request as file, then                 # as directory, then fall back to displaying a 404.                 #try_files $uri $uri/ =404;     ...
Read more