Foreign Key for MySQL Table

[lensoft]

Hi!

I just wanted to make a simple relationship between two basic tabes, that I've created. To make this action, I use "dbForge Studio for MySQL" but when I tried to create the connection, the software said the following:

 

So, what to do? Your servers/setup do not provide to make foreign keys?

 

Thanks for all!

[wolstech]

You probably need to change engines to InnoDB.

 

We default to Myisam because it tolerates load and crashes very well. InnoDB basically goes corrupt if you so much as look at it wrong.

[lensoft]

You probably need to change engines to InnoDB.

 

We default to Myisam because it tolerates load and crashes very well. InnoDB basically goes corrupt if you so much as look at it wrong.

Thank you! It helped me.