Simple bash script to sync remote mysql db to local

mysql_db_sync

#!/bin/bash

LOCAL_DB=""
REMOTE_DB=""

LOCAL_USER="root"
LOCAL_PASS=""

REMOTE_USER="root"
REMOTE_PASS=''

#user@host or host
REMOTE_HOST=""
REMOTE_PORT="22"

echo "Start clear db $LOCAL_DB"

echo "drop database IF EXISTS $LOCAL_DB;" | mysql -u$LOCAL_USER -p$LOCAL_PASS
echo "CREATE DATABASE $LOCAL_DB DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;" | mysql -u$LOCAL_USER -p$LOCAL_PASS

# echo "show databases;" | mysql -u$LOCAL_USER -p$LOCAL_PASS

echo "Start copy from $REMOTE_DB ($REMOTE_HOST) to $LOCAL_DB"

ssh -C -p $REMOTE_PORT $REMOTE_HOST mysqldump -u$REMOTE_USER -p$REMOTE_PASS $REMOTE_DB | pv | mysql -u$LOCAL_USER -p$LOCAL_PASS $LOCAL_DB

echo "Done... (in $SECONDS sec.)"

whit this solution, we have problem on big databases.
it makes us to wait till the mysqldump transfer between servers.
so, is there any way to just sync databases when the source is updated?
and also sync only the updated records?

Nice idea.

It may be enhanced and sped up by zipping up the sql dump and scping the zipped file.

I Like this.
I still search this script.

Thanks bro