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


HOW TO REMOVE WINDOWS 10 WELCOME SCREEN

HOW TO REMOVE WINDOWS 10 WELCOME SCREEN

Have you been getting the blue Windows 10 Welcome screen? It normally pops up after installing Windows 10 or after a Windows 10 update. I’ve been receiving a lot of questions relating to this and there are a few ways to remove it. One way it to change the settings in the registry setting but […]

read more
6 REASONS TO SYNCHRONIZE YOUR DATA

6 REASONS TO SYNCHRONIZE YOUR DATA

Technology changes and complex business requirements might compromise product data, impacting negatively on the company. Data synchronization ensures that information across the production chain is consistent. BizCaps achieves such streamlining with tools that collect data and sync it from the supplier to the consumer, increasing efficiency. Here are six reasons you require data synchronization. Increased […]

read more

Subscribe

Receive the latest news and awesome deals via email

Like our Page

site auditing tools