Azure database for MySQL - foreign key checks option

Jesus Gaibor Yanez 1

Hello M,
Can you help us with a variable to manage the foreign_key_checks option is basic variable to migrate data.

Oury Ba-MSFT 19,501 Reputation points Microsoft Employee

2021-10-15T15:57:14.957+00:00

@Jesus Gaibor Yanez Thank you for posting your posting your question on Microsoft Q&A. Could you please briefly describe the issue you are facing with Migration.

Regards,
Oury
Jesus Gaibor Yanez 1 Reputation point

2021-10-18T15:54:23.32+00:00

yeah, I want to migrate using data factory script, that script use a table by table method and we need to disable foreign key temporary..

1 answer

Oury Ba-MSFT 19,501 Reputation points Microsoft Employee

2021-12-08T21:00:56.727+00:00

@Jesus Gaibor Yanez

You can skip it at the connection level

I.e.: mysql --init-command="SET SESSION FOREIGN_KEY_CHECKS=0;" ...

REF - https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html#option_mysql_init-command

https://stackoverflow.com/questions/15938786/disabling-foreign-key-checks-on-the-command-line

Regards,
Oury
Please sign in to rate this answer.
Oury Ba-MSFT 19,501 Reputation points Microsoft Employee

2021-12-09T23:50:50.35+00:00

@Jesus Gaibor Yanez

Just checking in if you have had a chance to see the previous response.
Please enable your preferred alert types on your Profile's Settings to get instant notifications on this thread's discussions. Here is how to subscribe to a notification.

Please comment in the below section if you need further help in this matter!

Regards,
Oury

Oury Ba-MSFT 19,501 Reputation points Microsoft Employee

2021-12-10T23:09:25.557+00:00

@Jesus Gaibor Yanez Let me know if there are still any additional issues I can help with. If the answer above was helpful, then mark as accepted answer so it will be helpful for other community members facing the same.

Regards,
Oury

Dario Carta Mantiglia 5 Reputation points

2024-05-06T16:26:47.0766667+00:00

@Oury Ba-MSFT Could you please clarify what do you mean on "Connection level"?

I've configured MySql connection on my ADF, but I'm not getting where I should set the command.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure database for MySQL - foreign key checks option

1 answer

Your answer