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

InnoDB

forums › forums › SQLyog › Using SQLyog › InnoDB

  • This topic is empty.
Viewing 13 reply threads
  • Author
    Posts
    • February 14, 2003 at 11:57 am #7689
      Neshi
      Member

      Hello!

      I can't use the Table Type InnoDB. Every time I update my tables or create new tables (InnoDB Type of course) I get table type MyIsam.

      Could you please help me and tell me what I have to change and where I have to change?!

      Thanx so much!!!!

      😕 😕 😕 😕 😕 😕 😕

    • February 14, 2003 at 1:53 pm #13725
      Ritesh
      Member

      Make sure that the correct MySQL Server is running. To enable InnoDB with MySQL, you need to run mysqld-max-nt and not mysqld.

      Also, you need to tweak a little the my.ini file. More information can be found in the MySQL Docs.

    • February 17, 2003 at 10:31 am #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!

    • February 17, 2003 at 1:53 pm #13727
      Ritesh
      Member

      Can you give us more information about your MySQL Server, OS and the complete command line options which you use to start the MySQL Server Daemon.

      A post of your my.ini will also be helpful 🙂

    • February 17, 2003 at 7:56 pm #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!!!

    • February 17, 2003 at 9:15 pm #13729
      Ritesh
      Member

      Make sure that a directory called idbata exist in the c:mysql, then add this line in the mysqld section

      innodb_data_home_dir = c:/mysql/ibdata

      Then start the mysql daemon with the following parameters –

      mysqld-max-nt –basedir=c:/mysql –innodb_data_file_path=ibdata1:30M:autoextend –innodb_data_home_dir=c:/mysql/ibdata

      I believe this will start the MySQL with proper information.

    • February 18, 2003 at 10:28 am #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!

    • February 18, 2003 at 1:27 pm #13731
      Ritesh
      Member

      InnoDB wont be creating multiple files as MyISAM table handler. All the table will only be in one file i.e. the innodb tablespace.

    • February 19, 2003 at 9:17 am #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…..

    • February 19, 2003 at 10:23 am #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!

    • February 19, 2003 at 4:24 pm #13734
      CalEvans
      Member

      Checking my Windows box running mysql(YES, I keep one around just to prove it CAN be done) Go to the WinMySQLadmin program. (Mine is running in my status bar) Find the variables tab. Find the variable have_innodb. Does it say yes?

      =C=

    • February 20, 2003 at 1:49 pm #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!

    • February 20, 2003 at 5:27 pm #13736
      CalEvans
      Member

      Usually, this is a compile issue, not a cnf issue. (I could be wrong here)

      Grab the latest MySQLMax from http://www.mysql.com and re-install. (backup your existing data first!0

      =C=

    • February 21, 2003 at 9:33 am #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….

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