Bash Script for mysql dump

Easy Elephant answered on September 8, 2022 Popularity 4/10 Helpfulness 3/10

answer Bash Script for mysql dump

Bash Script for mysql dump

Comment

#!/bin/bash

USER="zend"
PASSWORD=""
#OUTPUT="/Users/rabino/DBs"

#rm "$OUTPUTDIR/*gz" > /dev/null 2>&1

databases=`mysql -u $USER -p$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database`

for db in $databases; do
    if [[ "$db" != "information_schema" ]] && [[ "$db" != "performance_schema" ]] && [[ "$db" != "mysql" ]] && [[ "$db" != _* ]] ; then
        echo "Dumping database: $db"
        mysqldump -u $USER -p$PASSWORD --databases $db > `date +%Y%m%d`.$db.sql
       # gzip $OUTPUT/`date +%Y%m%d`.$db.sql
    fi
done

Popularity 4/10 Helpfulness 3/10 Language sql

Source: stackoverflow.com

Tags: bash dump mysql script sql

Link to this answer
Share Copy Link

Contributed on Sep 08 2022

Easy Elephant

0 Answers Avg Quality 2/10

Bash Script for mysql dump

Contents

More Related Answers

Bash Script for mysql dump

Grepper

Documentation

Social

Legal

Contact

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