# Mysql cdc to kafka connect is running, but there is no messages show up in the topic **URL:** \ **Category:** 100 Days of Code\ **Created:** [15 March 2022 05:03 UTC](https://forum.confluent.io/t/mysql-cdc-to-kafka-connect-is-running-but-there-is-no-messages-show-up-in-the-topic/4453 "2022-03-15T05:03:12Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![xsqian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/xsqian/32/1534_2.png) [@xsqian](https://forum.confluent.io/u/xsqian)\ **Post date:** [15 March 2022 05:03 UTC](https://forum.confluent.io/t/mysql-cdc-to-kafka-connect-is-running-but-there-is-no-messages-show-up-in-the-topic/4453/1 "2022-03-15T05:03:12Z")
Hi there, I am following this hands-on lab to create a MySQL CDC connect to the Kafka cluster in the confluent cloud. > **[How to Stream Data from MySQL to Confluent Cloud Using CDC](https://developer.confluent.io/learn-kafka/data-pipelines/mysql-data-to-kafka-with-kafka-connect/)** > > Use a fully managed MySQL CDC Source Connector on Confluent Cloud to stream data from a sample external MySQL database into an Apache Kafka topic. The connect does show a “running” state, however, there is no messages to the topic. I am wondering if this is something reproducible for you or it works fine for you out there. > Thanks, Xingsheng ---
**Author:** ![mkananizadeh](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@mkananizadeh](https://forum.confluent.io/u/mkananizadeh)\ **Post date:** [15 March 2022 19:53 UTC](https://forum.confluent.io/t/mysql-cdc-to-kafka-connect-is-running-but-there-is-no-messages-show-up-in-the-topic/4453/2 "2022-03-15T19:53:29Z")
Hi @xsqian, If you navigate to Confluent Cloud → Topics, how many topics do you see that start with `mysql`? ---
**Author:** ![xsqian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/xsqian/32/1534_2.png) [@xsqian](https://forum.confluent.io/u/xsqian)\ **Post date:** [16 March 2022 05:17 UTC](https://forum.confluent.io/t/mysql-cdc-to-kafka-connect-is-running-but-there-is-no-messages-show-up-in-the-topic/4453/3 "2022-03-16T05:17:32Z")
Hi @mkananizadeh There are 2 topics that start with MySQL: mysql01 mysql01.demo.CUSTOMERS ![Screen Shot 2022-03-15 at 10.15.55 PM](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/2X/2/20ba0aefd6f831bf020df28ab75d8f6320509a86.png) ---
**Author:** ![xsqian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/xsqian/32/1534_2.png) [@xsqian](https://forum.confluent.io/u/xsqian)\ **Post date:** [16 March 2022 05:19 UTC](https://forum.confluent.io/t/mysql-cdc-to-kafka-connect-is-running-but-there-is-no-messages-show-up-in-the-topic/4453/4 "2022-03-16T05:19:36Z")
![image](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/2X/7/73baabf824ccf4fd9f3112054b61af05c6da2b11.png) ---
**Author:** ![xsqian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/xsqian/32/1534_2.png) [@xsqian](https://forum.confluent.io/u/xsqian)\ **Post date:** [16 March 2022 05:20 UTC](https://forum.confluent.io/t/mysql-cdc-to-kafka-connect-is-running-but-there-is-no-messages-show-up-in-the-topic/4453/5 "2022-03-16T05:20:16Z")
![image](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/2X/0/08096335fa2e779d18271a99623b5df1b75450e9.png) ---
**Author:** ![mkananizadeh](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@mkananizadeh](https://forum.confluent.io/u/mkananizadeh)\ **Post date:** [16 March 2022 16:21 UTC](https://forum.confluent.io/t/mysql-cdc-to-kafka-connect-is-running-but-there-is-no-messages-show-up-in-the-topic/4453/6 "2022-03-16T16:21:53Z")
> [@xsqian](#): > > mysql01.demo.CUSTOMERS Thank you for including screenshots @xsqian ! When you change the offset to 0, do you see anything? I attached a screen recording from my setup as a reference ![Screen Recording 2022-03-16 at 09.18.14 AM](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/2X/d/d00667ef9c7e1e1d4fc6197d207f372311a7e75b.gif) . ---
**Author:** ![xsqian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/xsqian/32/1534_2.png) [@xsqian](https://forum.confluent.io/u/xsqian)\ **Post date:** [20 March 2022 15:15 UTC](https://forum.confluent.io/t/mysql-cdc-to-kafka-connect-is-running-but-there-is-no-messages-show-up-in-the-topic/4453/7 "2022-03-20T15:15:14Z")
Actually the option for the drop-down for the offset it faded out for me ---
**Author:** ![mkananizadeh](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@mkananizadeh](https://forum.confluent.io/u/mkananizadeh)\ **Post date:** [22 March 2022 00:15 UTC](https://forum.confluent.io/t/mysql-cdc-to-kafka-connect-is-running-but-there-is-no-messages-show-up-in-the-topic/4453/8 "2022-03-22T00:15:51Z")
@xsqian is that the same thing with your `mysql01` topic? ---
**Author:** ![xsqian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/xsqian/32/1534_2.png) [@xsqian](https://forum.confluent.io/u/xsqian)\ **Post date:** [22 March 2022 05:49 UTC](https://forum.confluent.io/t/mysql-cdc-to-kafka-connect-is-running-but-there-is-no-messages-show-up-in-the-topic/4453/9 "2022-03-22T05:49:42Z")
Hi @mkananizadeh It’s the same for the `mysql01` topic. Please see the screenshots below: ![Screen Shot 2022-03-21 at 10.46.04 PM](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/2X/a/a2805868a0482c8617f63243dd3baae02f5af6e0.jpeg) ---
**Author:** ![mkananizadeh](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@mkananizadeh](https://forum.confluent.io/u/mkananizadeh)\ **Post date:** [22 March 2022 16:06 UTC](https://forum.confluent.io/t/mysql-cdc-to-kafka-connect-is-running-but-there-is-no-messages-show-up-in-the-topic/4453/11 "2022-03-22T16:06:05Z")
Could you type into the `offset` box? If you can, please enter `0` and then pick` 0 / Partition: 0`. ---
**Author:** ![xsqian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/xsqian/32/1534_2.png) [@xsqian](https://forum.confluent.io/u/xsqian)\ **Post date:** [23 March 2022 03:21 UTC](https://forum.confluent.io/t/mysql-cdc-to-kafka-connect-is-running-but-there-is-no-messages-show-up-in-the-topic/4453/12 "2022-03-23T03:21:44Z")
@mkananizadeh Actually there are messages in the mysql01 topic once I enter 0 and then pick `0 / partition: 0` Here is the screenshot: ![Screen Shot 2022-03-22 at 7.56.28 PM](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/2X/9/97a3bb087da47368605ddc2a63114178a52b1760.jpeg) ---
**Author:** ![xsqian](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/xsqian/32/1534_2.png) [@xsqian](https://forum.confluent.io/u/xsqian)\ **Post date:** [23 March 2022 03:27 UTC](https://forum.confluent.io/t/mysql-cdc-to-kafka-connect-is-running-but-there-is-no-messages-show-up-in-the-topic/4453/13 "2022-03-23T03:27:43Z")
@mkananizadeh Also, after all the trouble, I found the issue: the issue is when creating a connection, I need to have the `demo.` in front of table `CUSTOMERS`, so table to include should be `demo.CUSTOMERS`. Before I though since I put the `demo` to the include database field, so I only need `CUSTOMERS` in the include table field. Apparently that not the case, always need `demo.CUSTOMERS`. Please see the screenshot. Thank you for your help! ![Screen Shot 2022-03-22 at 8.09.49 PM](https://us1.discourse-cdn.com/flex019/uploads/confluentcommunity/original/2X/0/0a37a900be736cd9e4a5abb7510344ba6b01a7dc.jpeg) ---
**Author:** ![mkananizadeh](https://avatars.discourse-cdn.com/v4/letter/m/cab0a1/32.png) [@mkananizadeh](https://forum.confluent.io/u/mkananizadeh)\ **Post date:** [23 March 2022 14:46 UTC](https://forum.confluent.io/t/mysql-cdc-to-kafka-connect-is-running-but-there-is-no-messages-show-up-in-the-topic/4453/14 "2022-03-23T14:46:03Z")
Glad to hear you got it working 🙂