Backup & restore sekaligus

Membackup mysql antar server :

server1 :
ip : 10.42.2.26
database divarea

server2 :
ip : 10.41.11.15
database divarea

Jgn lupa create database kosong dulu di 10.41.11.15

gini scriptnya :
masuk SSH ke 10.42.2.26 dulu, kemudian ketik sbb :

mysqldump -uweb2 -p123456gh --host=10.42.2.26 divarea | mysql -u web2 -p123456xy --host=10.41.11.15 -C divarea