I wanted to sync data between two databases.
Namely shipnee1 and ship_tor. the thing is that both the databases will be on same server and have a exclusion for table.
I tried setting up cron job
/usr/bin/mysqldump -h localhost -u ship_tor -p'ship_tor' ship_tor --ignore-table=ship_tor.tblconfiguration | /usr/bin/mysql -h localhost -u shipnee1 -p'shipnee1' shipnee1
and
/usr/bin/mysqldump -h localhost -u shipnee1 -p'shipnee1' ship_tor --ignore-table=shipnee1.tblconfiguration | /usr/bin/mysql -h localhost -u ship_tor -p'ship_tor' ship_tor
Also, The Data is being deleted and then imported.
I want it to be on a incremental basis. Help will be appriciated