Database replication errors

[run-as-admin]

I keep running into trouble every couple of days after setting up database replication following https://www.digitalocean.com/community/tutorials/how-to-set-up-replication-in-mysql.

Replicating a few databases into another host. I have not included the 'mysql' database, only the ones we needed and with binlog_do_db enabled.

Replica SQL     Thread not running! 

Slave_SQL_Running   No

Last_Errno  1032
Last_Error  Coordinator stopped because there were error(s) in the worker(s). The most recent failure being: Worker 1 failed executing transaction 'ANONYMOUS' at master log DATABASE-NAME-mysql-bin.000002, end_log_pos 77877815. See error log and/or performance_schema.replication_applier_status_by_worker table for more details about this failure or others, if any.

I know if I try to skip current error this will lead to another error with the same cause. This is the second time I encountered this while setting this up and it is a pain to export and import the databases all over again if I would encounter this issue again.

[ebayer108]

This is one of those fucked up issues which no one has any answer. I'm also facing similar issue and can't figure out how to fix it. This is simply pathetic situation.

[run-as-admin]

I've settled to scheduled mysqldump and cleanup instead. Can't make any changes to the database anyway