Cacher is the code snippet organizer for pro developers

#!/bin/bash

# -- Configuration
REMOTE_BACKUP_DIR=/lamp0/tmp/mysql_backup  
LOCAL_BACKUP_DIR=Your_path

TODAY_DATE=$(date +%F)  
FILENAME=$TODAY_DATE.databases.sql.gz  
SERVER='sftp.dc0.gpaas.net'  
LOGIN=your_login_server  
PASS=your_password_server

LOCAL_LOGIN=  
LOCAL_PASSWORD=  
#Download

if [ -f $LOCAL_BACKUP_DIR/$FILENAME ]  
then  
echo "Backup $FILENAME already downloaded"  
else  
sftp $LOGIN:$PASS@$SERVER:$REMOTE_BACKUP_DIR/$FILENAME $LOCAL_BACKUP_DIR/  
fi

# Suppression de la base
mysqladmin -u$LOCAL_LOGIN -p$LOCAL_PASSWORD drop your_db

# Création de la base
mysql -u$LOCAL_LOGIN -p$LOCAL_PASSWORD -e "create database your_db"

# Import de la copie
gunzip < $LOCAL_BACKUP_DIR/$FILENAME | mysql -u $LOCAL_LOGIN -p$LOCAL_PASSWORD -h localhost your_db