set -x
sudo systemctl stop mariadb.service
sudo rm -rf backup1
sudo rm -rf /var/lib/mysql
sudo mariadb-install-db
sudo chown mysql:mysql /var/lib/mysql -R
sudo systemctl start mariadb.service


echo "CREATE OR REPLACE USER test_user@'%' IDENTIFIED BY 'ct570c3521fCCR#'" | sudo mariadb
echo "CREATE OR REPLACE USER test_user@'localhost' IDENTIFIED BY 'ct570c3521fCCR#'" | sudo mariadb
echo "GRANT ALL PRIVILEGES ON *.* TO test_user@'%'" | sudo mariadb
echo "GRANT ALL PRIVILEGES ON *.*  TO test_user@'localhost'" | sudo mariadb

echo "DROP DATABASE IF EXISTS test" | sudo mariadb
echo "CREATE DATABASE test" | sudo mariadb
echo "CREATE TABLE table1 (i INT, s VARCHAR(1024))" | mariadb -utest_user -pct570c3521fCCR# test
echo "CREATE TABLE table2 (i INT, s VARCHAR(1024))" | mariadb -utest_user -pct570c3521fCCR# test
echo "CREATE TABLE table10 (i INT, s VARCHAR(1024))" | mariadb -utest_user -pct570c3521fCCR# test


sudo mariadb-backup --backup -utest_user -pct570c3521fCCR# --target-dir=backup1


sudo systemctl stop mariadb.service
sudo rm -rf /var/lib/mysql
sudo mariadb-install-db
sudo chown mysql:mysql /var/lib/mysql -R
sudo systemctl start mariadb.service


echo "CREATE OR REPLACE USER test_user@'%' IDENTIFIED BY 'ct570c3521fCCR#'" | sudo mariadb
echo "CREATE OR REPLACE USER test_user@'localhost' IDENTIFIED BY 'ct570c3521fCCR#'" | sudo mariadb
echo "GRANT ALL PRIVILEGES ON *.* TO test_user@'%'" | sudo mariadb
echo "GRANT ALL PRIVILEGES ON *.*  TO test_user@'localhost'" | sudo mariadb

echo "CREATE TABLE table1 (i INT, s VARCHAR(1024))"  | mariadb -utest_user -pct570c3521fCCR# test
echo "CREATE TABLE table10 (i INT, s VARCHAR(1024))"  | mariadb -utest_user -pct570c3521fCCR# test

echo "ALTER TABLE table1 DISCARD TABLESPACE"  | mariadb -utest_user -pct570c3521fCCR# test
echo "ALTER TABLE table10 DISCARD TABLESPACE"  | mariadb -utest_user -pct570c3521fCCR# test

sudo mariadb-backup --prepare --export --target-dir=backup1

#sudo systemctl stop mariadb.service
sudo cp backup1/test/table1.cfg /var/lib/mysql/test/
sudo cp backup1/test/table1.ibd /var/lib/mysql/test/
sudo chown mysql:mysql /var/lib/mysql -R
#sudo systemctl start mariadb.service

echo "ALTER TABLE table1 IMPORT TABLESPACE"  | mariadb -utest_user -pct570c3521fCCR# test