MySQL binary Logging must use ROW format error

0

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

  • i am also facing same issue can you help me out on this

chifli
질문됨 3년 전1761회 조회
1개 답변
0

I was missing some stuff

chifli
답변함 3년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠