Export and Import Databases from MySQL to Galera Cluster

mysql -uroot -p

FLUSH TABLES WITH READ LOCK;

mysql -uroot -p

UNLOCK TABLES;

cat << 'EOL'>export.sh
#!/bin/bash
pass=

db=power
mysqldump -u root -p$pass --skip-create-options $db > $db.sql
db=money
mysqldump -u root -p$pass --skip-create-options $db > $db.sql
tar zcvf sql.skip.create.options.tgz *.sql
scp sql.skip.create.options.tgz root@server:/root/ 
EOL

cat << 'EOL'>import.sh
#!/bin/bash

tar zxvf sql*.tgz

db=power
mysql -e "create database $db;"
mysql $db < $db.sql
db=money 
mysql -e "create database $db;"
mysql $db < $db.sql
mysql_upgrade

EOL
chmod +x import.sh
./import.sh