#!/bin/bash
#Avoid names that contains a hyphen e.g. my-db - this script will eventually not work with hyphens. OK is my_db
dbuser=iliasuser
dbnameori=ildb
dbnameclone=ildb_clone 
##############################################
 
#mysql --execute="DROP DATABASE ${dbnameclone};"
 
 
mysql --execute="CREATE DATABASE ${dbnameclone} CHARACTER SET utf8 COLLATE utf8_general_ci;"
 
mysql --execute="GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, INDEX, DROP, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES ON ${dbnameclone}.* TO '${dbuser}'@'localhost';"
 
 
if [ -f "${dbnameclone}.sql" ] ; then
        echo "deleting old backupfile ${dbnameclone}.sql from disk";
        rm "${dbnameclone}.sql"
fi
echo "Copying DB ${dbnameori} into a file on disk named ${dbnameclone}.sql";
mysqldump ${dbnameori} > ${dbnameclone}.sql
echo "Copying ${dbnameclone}.sql into ${dbnameclone}";
mysql ${dbnameclone} < ${dbnameclone}.sql
echo "End";
 
mysql --execute="SHOW DATABASES";