[MySQL - export and import database] #mysql #mysqldump #docker #mariadb #gunzip

mysql_export.sh

#!/bin/bash
DATE=$(date "+%Y%m%d%H%M%S")
DBUSER=$1
DBPASS=$2
DBNAME=$3

mysqldump -u $DBUSER --password=$DBPASS $DBNAME | gzip > /path/to/dump/$DBNAME$DATE.sql.gz

mysql_import.sh

#!/bin/bash
DBUSER=$1
DBPASS=$2
DBNAME=$3
DBFILE=$4

mysql -u$DBUSER -p$DBPASS $DBNAME < $DBFILE

mysql_import_gzip.sh

#!/bin/bash
DBUSER=$1
DBPASS=$2
DBNAME=$3
DBFILE=$4

gunzip -dc < $DBFILE | mysql -u$DBUSER -p$DBPASS $DBNAME