topic Re: How can I create MySql table with MyISAM engine in Talend Studio

How can I create MySql table with MyISAM engine

Anonymous — Sat, 16 Nov 2024 05:32:51 GMT

Hi,

I create tables in mysql database with tMySqlOutput and I see table type is InnoDB but it is not why I want.

I want table type MyISAM in MySql database table. How can I resolved in talend job.

I used job tFileList-->tFileInputPositional-->tDBOutput

Thanks,

Betul

Re: How can I create MySql table with MyISAM engine

Anonymous — Wed, 19 Jun 2019 21:34:13 GMT

Hi,

Did you try to give ENGINE = MyISAM in the additional JDBC parameter of Advanced section of the component?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: How can I create MySql table with MyISAM engine

Anonymous — Thu, 20 Jun 2019 07:16:22 GMT

Hi Nikhil,

My job is this picture and I tried the additional JDBC parameter but it's not work. Maybe I missed another subject.

Can you check my job, please?

talend.png

Re: How can I create MySql table with MyISAM engine

Anonymous — Fri, 21 Jun 2019 12:02:42 GMT

Hi Nikhil,

Can you help me this subject, please?

I can't figure out and my situtation is emegercy.

Thanks a lot,

Betul

Re: How can I create MySql table with MyISAM engine

Anonymous — Fri, 21 Jun 2019 14:15:19 GMT

Hi,

Unfortunately I am tied up with some important work today and I need to do some environment setup before checking on this issue.

If it is something urgent, I would suggest to raise a support ticket so that they can advise you about the next steps at the earliest.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂