#!/bin/bash

## MOTS DE PASSE ##
new_password='' # A SURCHARGER
old_password='' # A SURCHARGER

## BASES DE DONNEES
new_host='mysql-e884938b-o403ac517.database.cloud.ovh.net'
new_port=20184

old_host='51.91.81.188'
old_port=54322

# Si le user est le même que le nom de base
if [[ -n "$USER" ]]; then
    USER=$DB_NAME
fi

# Créer la nouvelle base - user - privilèges
query="CREATE DATABASE IF NOT EXISTS \`${DB_NAME}\`;CREATE USER IF NOT EXISTS \`${USER}\`@'%' IDENTIFIED BY '${PASSWORD}';GRANT ALL PRIVILEGES ON \`${DB_NAME}\`.* TO \`${USER}\`@'%';"

mariadb -h ${new_host} -P ${new_port} -u avnadmin --password=${new_password} -e "${query}"

# Dump ancienne base
mysqldump -h ${old_host} -P ${old_port} -u root --password=${old_password} ${DB_NAME} > /tmp/${DB_NAME}.sql

# Load nouvelle base
mariadb -h ${new_host} -P ${new_port} -u avnadmin --password=${new_password} ${DB_NAME} < /tmp/${DB_NAME}.sql

# Supprimer le dump
rm /tmp/${DB_NAME}.sql