SCRIPT TO BACKUP ALL MYSQL DATABASES IN VESTACP

December 11, 2019   /   by Marco  / Categories :  Business
Business Legions - SCRIPT TO BACKUP ALL MYSQL DATABASES IN VESTACP

If you have multiple databases hosted on VestaCP the easiest way I found to backup all the databases is to use a script. The first thing you need to do is create a backup account in mySQL that has view only access to all the databases.

Then use this bash script. You can change the variables accordingly but the most important is the backup location, username and password which was created above:

#! /bin/bash

TIMESTAMP=$(date +”%F”)
BACKUP_DIR=”/web/backup/$TIMESTAMP”
MYSQL_USER=”xxx”
MYSQL=/usr/bin/mysql
MYSQL_PASSWORD=”xxx”
MYSQLDUMP=/usr/bin/mysqldump

mkdir -p “$BACKUP_DIR/mysql”

databases=$MYSQL --user=$MYSQL_USER -p$MYSQL_PASSWORD -e "SHOW DATABASES;" | grep -Ev "(Database|information_schema|performance_schema)"

for db in $databases; do
$MYSQLDUMP –force –opt –user=$MYSQL_USER -p$MYSQL_PASSWORD –databases $db | gzip > “$BACKUP_DIR/mysql/$db.gz”
done

Business Legions - SCRIPT TO BACKUP ALL MYSQL DATABASES IN VESTACP

Hopefully, this has helped someone.

DO YOU LIKE WHAT YOU'VE READ?
Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!

Our Sponsors

  • Follow us:

OTHER ARTICLES YOU MAY LIKE


6 THING TO KNOW ABOUT USING A HEADER BIDDER

6 THING TO KNOW ABOUT USING A HEADER BIDDER

Header bidding is increasing in popularity rapidly. Publishers are looking for new ways to increase revenue, and header bidding seems to be the answer. But with increased popularity comes misunderstandings about how header bidder works and how publishers can maximise yield using this technology. Here are some things that every publisher should know before implementing […]

read more
LOOKING FOR AN ONLINE BOOKING TOOL?

LOOKING FOR AN ONLINE BOOKING TOOL?

If you’re looking at an online booking tool that will easily integrate and work with your website you can check out this post: HOW TO ADD THE TIDYCAL BOOKINGS PAGE TO A WORDPRESS PAGE This is the tool used: TIDYCAL – SIMPLE BOOKING SOLUTION there is a free version that you can use and if […]

read more

Subscribe

Receive the latest news and awesome deals via email

Like our Page

site auditing tools