31 lines
953 B
Bash
31 lines
953 B
Bash
#!/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
|