MySQL binary Logging must use ROW format error
I'm trying for first time to use DMS to migrate and keep in sync a database while I migrate our site to aws but I keep getting :
Last Error Failed in resolving configuration. Task error notification received from subtask 0, thread 0 [reptask/replicationtask.c:2859] [1020418] Error Code [10002] : MySQL binary Logging must use ROW format; Errors in MySQL server binary logging configuration. Follow all prerequisites for 'MySQL as a source in DMS' from https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.MySQL.html or'MySQL as a target in DMS' from https://docs.aws.amazon.com/dms/latest/userguide/CHAP_Target.MySQL.html ; Failed while preparing stream component 'st_0_ZJFFAMOOBGXIX26POQR3LG6TVKDJFXFVACA4QCQ'.; Cannot initialize subtask; Stream component 'st_0_ZJFFAMOOBGXIX26POQR3LG6TVKDJFXFVACA4QCQ' terminated [reptask/replicationtask.c:2866] [1020418] Stop Reason FATAL_ERROR Error Level FATAL
I did follow all steps and source database it's already in ROW format
task:
arn:aws:dms:us-east-1:254218654658:task:RNPUCUQVEMS4Q46SV6FX2GCTW36VFJ6ZELIUTJI
Relevant questions
DMS to migrate SQL Server from RDS to EC2
asked 2 years agoKeep getting network error trying to sign up to AWS DeepRacer student
Accepted Answerasked 6 months agoMigrate tables with LOBs from RDS MySQL to OpenSearch using DMS
asked 10 days agoMigrate MySQL 8 to Aurora MySQL 8
asked 3 months agomigrate database from my local to AWS
Accepted Answerasked 3 years agoHow do I keep the time in sync in docker based lambda functions
Accepted Answerasked 4 months agoMySQL binary Logging must use ROW format error
asked a year agoMigrate MySQL 5.5 to AWS
Accepted AnswerBinary Logging must be enabled for MySQL server
Accepted Answerasked 18 days agoNeed help understanding error when trying to configure database on Elastic beanstalk: Engine Version 5.6 not supported for mysql db
asked 3 months ago