This is an old revision of the document!
NOTE : it not fully written there is many changes needed.
#!/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