echo %DATE%_%TIME%
ECHO Stop Replication process 
"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqladmin" --user=root --password=K4*#4Uh@3n6-$lD1 stop-slave


ECHO Backup Databases

"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqldump" --user=root --password=K4*#4Uh@3n6-$lD1 --opt MyPAYELive --ignore-table=mypayelive.activity_items --ignore-table=mypayelive.activity_log --ignore-table=mypayelive.activity_notes --ignore-table=mypayelive.xml_web_service_calls > D:\MySQLRepl_Backup\MyPAYELive.sql



ECHO Restart Replication process

"C:\Program Files\MySQL\MySQL Server 8.0\bin\mysqladmin" --user=root --password=K4*#4Uh@3n6-$lD1 start-slave

echo %DATE%_%TIME%
PAUSE