[ Avaa Bypassed ]

#!/bin/bash

#empty db
printf "DROP database test_db;" | docker exec -i bayadicbot_db_1 /usr/bin/mysql -u root --password=my_secret_pw_shh 
printf "DROP database test_swedish_db;" | docker exec -i bayadicbot_db_1 /usr/bin/mysql -u root --password=my_secret_pw_shh 

printf "CREATE database test_db;" | docker exec -i bayadicbot_db_1 /usr/bin/mysql -u root --password=my_secret_pw_shh;
printf "CREATE database test_swedish_db;" | docker exec -i bayadicbot_db_1 /usr/bin/mysql -u root --password=my_secret_pw_shh;

# Restore
cat telegram_german_bot.sql | docker exec -i bayadicbot_db_1 /usr/bin/mysql -u root --password=my_secret_pw_shh test_db
# cat init.sql | docker exec -i bayadicbot_db_1 /usr/bin/mysql -u root --password=my_secret_pw_shh
echo "IMPORTANT ---- THE IMPORT PROCESS MUST BE FINISHED WITHOUT ERROR -----"
cat telegram_swedish_bot.sql | docker exec -i bayadicbot_db_1 /usr/bin/mysql -u root --password=my_secret_pw_shh test_swedish_db
printf "use mysql; GRANT ALL ON test_swedish_db.* TO 'devuser'; FLUSH PRIVILEGES;" | docker exec -i bayadicbot_db_1 /usr/bin/mysql -u root --password=my_secret_pw_shh;

# Backup
docker exec bayadicbot_db_1 /usr/bin/mysqldump -u root --password=my_secret_pw_shh test_db > telegram_german_bot_bak.sql
docker exec bayadicbot_db_1 /usr/bin/mysqldump -u root --password=my_secret_pw_shh test_swedish_db > telegram_swedish_bot_bak.sql