NOTE : it not fully written there is many changes needed.
#!/bin/bash #----------change following #destination username d_User_nm=<username> #destination password d_Passwo=<password> #source username s_User_nm=<username> #source password s_Passwo=<password> Src_host=<source_server> Dst_host=<Destination_server> db_skp=mysql #------------no further DBS="$(mysql -h $Src_host --user=$s_User_nm --password=$s_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=$s_User_nm --password=$s_Passwo $db | mysql -h $Dst_host -u $d_User_nm -p$d_Passwo -D $db fi done