NOTE : it not fully written there is many changes needed.

<code bash | mysql_db_cp.sh> #!/bin/bash

User_nm=<username> Passwo=<password> Src_host=<source_server> Dst_host=<Destination_server> db_skp=mysql

DBS=“$(mysql -h $Src_host –user=$User_nm –password=$Passwo -Bse 'show databases')”

for db in ${DBS[@]} do if [ “$db” == “$db_skp” ]; then echo “mysql skipped” else echo “syncing database $db” mysqldump -h Src_host –user=$User_nm –password=$Passwo $db | mysql -h Dst_host -u root -pk83apuDrug -D $db fi done </done>