Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Relationships not imported

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Relationships not imported

  • This topic is empty.
Viewing 10 reply threads
  • Author
    Posts
    • November 11, 2003 at 4:12 am #8237
      Vee
      Member

      I have imported my database from MS ACCESS and have gone to link the databases but the relationships from the access database have not been imported.

      Why not?

      When I hit the relationship buttons it gives me this message:

      The selected table does not have InnoDB Table Handler

      You cannot Manage Relationships for the table

      Now I have no idea what that means but the last thing I wanna do is rectify the problem by manually typing in the million and one join statements in SQL

      How do I rectify the situation?

    • November 11, 2003 at 5:27 am #15213
      Ritesh
      Member

      SQLyog does not support FK in ODBC Import. This feature is planned for SQLyog Max.

      You cannot create relationships on tables with MyISAM table handlers. You have to use InnoDB Table handlers. For more information on InnoDB visit http://www.innodb.com

      HTH

    • November 11, 2003 at 5:42 am #15214
      Vee
      Member

      makes me wonder why I'm using the tool then 😉

      From the using sqlyog board I've learnt I have to change the type to InnoDB yet “change table type to” innodb doesn't work at all.

      How do I activate that? I suppose I have to visit innodb to find that out as well.

    • November 11, 2003 at 9:06 am #15215
      Ritesh
      Member

      You have to configure MySQL for InnoDB. After the server has been configured you can cconvert the table handlers to InnoDB using “Change Table Type To…” option.

      A very good tutorial on managing FK using SQLyog can be found at http://www.weberdev.com

    • November 11, 2003 at 11:39 am #15216
      Shadow
      Member
      Quote:
      How do I activate that? I suppose I have to visit innodb to find that out as well.

      I suggest you to check MySql manual's corresponding part (7.5 InnoDB Tables) first of all!

    • November 12, 2003 at 12:14 am #15217
      Vee
      Member

      Read it, as best as I can tell I have 3.23 or so

      that I have to download the max binary and install for it. Is this correct?

      And I cannot find the tutorial that you are referring to yet.

    • November 12, 2003 at 12:43 am #15218
      Vee
      Member

      If I'm right, its simple as changing the msqld file to mysqld-max under the my.ini setup tab

      I've done that, and added

      [mysqld]

      innodb_data_home_dir=

      innodb_data_file_path=/data/data1:100M:autoextend

      to it, which I think is wrong but what now?

    • November 12, 2003 at 6:20 am #15219
      Ritesh
      Member
      Quote:
      that I have to download the max binary and install for it. Is this correct?

      correct 😀

      A complete documentation on how to start MySQL with InnoDB support can be found at http://www.innodb.com

    • November 12, 2003 at 6:23 am #15220
      Vee
      Member

      so the mysqld-max.exe file in my bin isn't it then?

      As I said above I've made the above changes to the my.ini thru the winmysqladmin

    • November 13, 2003 at 3:09 am #15221
      Vee
      Member

      ok, a slight modification to the text I added to the my.ini got it to work and I can now change table types 😀

      Now to find how to use FK with SQLYOG and if its on http://www.weberdev.com I'll eat my hat

    • November 13, 2003 at 4:00 am #15222
      Vee
      Member

      ok, found it

      http://www.weberdev.com/ViewArticle.php3?ArticleID=352

      haven't used it yet but found it thx to google, no thx to the site search engine

      thx ritesh 🙂

  • Author
    Posts
Viewing 10 reply threads
  • You must be logged in to reply to this topic.