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

managing ralatioships

forums › forums › SQLyog › Using SQLyog › managing ralatioships

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • January 30, 2005 at 8:29 am #8760
      tahir
      Member

      hi

      i want to know how can i manage relationships on tables

      i know firts have to have the type of table 'innodb'

      but when i chenged its type its not working?

      how can i change it and manage realationships?

    • February 7, 2005 at 3:33 pm #16909
      x2egard
      Member

      Hi tahir,

      I'm on windows, using xampp, hope this helps:

      Go to your mysql/bin folder and edit the “my” file and uncomment the innodb lines —

      skip-innodb

      # Uncomment the following if you are using InnoDB tables

      innodb_data_home_dir = e:/apachefriends/xampp/mysql/

      innodb_data_file_path = ibdata1:10M:autoextend

      innodb_log_group_home_dir = e:/apachefriends/xampp/mysql/

      innodb_log_arch_dir = e:/apachefriends/xampp/mysql/

      Change the sever from “[mysqld]” to “[mysqld-max-nt]”

      Re-start mysql.

      Is the innodb type working? Try alter table , advanced properties, and select innodb from the pulldown.

      Now about this relationship thing. I got the innodb working, but no luck creating a relationship. Let me know if you succeed in creating a relationship!

      Ed

    • February 7, 2005 at 4:26 pm #16910
      Ritesh
      Member
      Quote:
      but no luck creating a relationship.

      Are you getting any error?

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