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

Forum Replies Created

Viewing 13 posts - 16 through 28 (of 28 total)
  • Author
    Posts
  • in reply to: Can't manage relationships… #13790
    Neshi
    Member

    This is what I have so far:

    [mysqld]

    datadir=C:/mysql/data

    innodb_data_file_path=ibdata1:30M:autoextend

    innodb_data_home_dir=C:/mysql/ibdata

    set-variable = innodb_buffer_pool_size=80M

    set-variable = innodb_additional_mem_pool_size = 20M

    set-variable = innodb_log_file_size = 20M

    set-variable = innodb_log_buffer_size = 8:

    innodb_flush_log_at_trx_commit = 1

    Do I need to create a new folder for the logs? And where do I have to create it if I have to???

    Oh, there are so many questions 🙄 🙁 🙄 🙁 🙄 🙁

    in reply to: Can't manage relationships… #13789
    Neshi
    Member

    Ritesh, I have an important question:

    I want to modify my my.ini with the InnoDB options.

    I have 512 MB RAM and lots of space for the tables (there are 200GB free, but of course I won't use them…).

    What kind of values would do I have to set up for a pretty good performance?

    Thanks a lot!

    in reply to: Can't manage relationships… #13788
    Neshi
    Member

    Yes, they have indexes!

    I really have no idea where the problem is!

    I will check the InnoDB homepage!!!

    Thank you!

    in reply to: Can't manage relationships… #13786
    Neshi
    Member

    HELLO?!?!?

    🙁 😀

    in reply to: Can't manage relationships… #13785
    Neshi
    Member

    Okay, i try to explain it properly….

    I have one table “user”

    User has the columns:

    -UserID (PrimaryKey)

    -WorkshopID (SHOULD BE the foreign key)

    -TeamID (should also be a foreign key)

    I tried to connect to the Tables “workshop” and “team”

    in both tables is an ID (as PrimaryKey obviously) and the name…

    So, I hope this helps!!!

    Thank you!

    in reply to: Can't manage relationships… #13783
    Neshi
    Member

    I am using InnoDB tables!!!! So where is the problem?!

    in reply to: InnoDB #13737
    Neshi
    Member

    It is working now!!!

    Thanks for your help!

    But now I have another problem… but therefore I have to create a new topic….

    in reply to: InnoDB #13735
    Neshi
    Member

    No, the value for innodb is disabled!!!! It seems as if it's ignoring the my.cnf (were I have the innodb info) completely!

    in reply to: InnoDB #13733
    Neshi
    Member

    I am using win 2000 at home and at work win nt!

    Do you think there could be the problem?!

    Please help!

    in reply to: InnoDB #13732
    Neshi
    Member

    It is not working ….

    Yesterday I changed the my.ini file at my computer at home and there it is working… Today I changed the my.ini file at work – but still innoDB table is disabled.

    What is wrong here?!?! Do you have any idea???

    The my.ini looks like this now:

    [WinMySQLAdmin]

    Server=C:/mysql/bin/mysqld-max-nt.exe

    [mysqld]

    mysqld-max-nt

    basedir=c:/mysql/ibdata

    innodb_data_file_path=ibdata1:30M:autoextend

    innodb_data_home_dir=c:/mysql/ibdata

    Do you need any more information? Can I send you a screenshot of my winmysqladmin (the part where you can see the information about my environment?

    It is so urgent…..

    in reply to: InnoDB #13730
    Neshi
    Member

    I think it is working !!! 🙂 🙂 🙂

    But now I have the next problem: where are the tables?! I can't find them!

    The folder ibdata is empty…

    Thank you for your help!

    in reply to: InnoDB #13728
    Neshi
    Member

    Hello!

    Here you get the contenct of the my.ini file:

    [WinMySQLAdmin]

    Server=C:/mysql/bin/mysqld-max-nt.exe

    [mysqld]

    innodb_data_file_path = ibdata1:10M:autoextend

    set-variable = innodb_buffer_pool_size=70M

    set-variable = innodb_additional_mem_pool_size=10M

    set-variable = innodb_log_file_size=20M

    set-variable = innodb_log_buffer_size=8M

    innodb_flush_log_at_trx_commit=1

    So, I hope this will bring us forward….

    Thank you a lot!!!

    in reply to: InnoDB #13726
    Neshi
    Member

    Hello!

    I have the correct MySQL server and I also changed the my.ini…..

    But it is still not working!

    Do you have any ideas how to enable the innoDB in this case?!

    Thanks so much!

Viewing 13 posts - 16 through 28 (of 28 total)