Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    35

    Unanswered: Help wiht InnoDB

    Hi,

    I have installed phpdev423 with success which contains MySQL4. My problem is that I need to create a booking system database and need InnoDB as opposed to MyISAM (for referential integrity). I have tried altering the tables to InnOB wihtout success. Even in the drop down menu the choice is 'heap', 'merge' or 'MyIsam'.

    Looking at the documentation I should have the option of choosing Innob in MySql4. Could anyone advise me how I could get Innodb? Would it require removing mySql?

    Many thanks,

    Mark

  2. #2
    Join Date
    Jan 2003
    Location
    Paris, France
    Posts
    320
    First make sure that innodb is configured on your server then you can alter your table by using alter table type = innodb
    Olivier Miossec
    --
    http://www.lasso-developpeur.net/
    --

  3. #3
    Join Date
    Sep 2003
    Posts
    35
    Hi,

    Being new to this could you explain where I have to configure this. How do I get to the files and what lines do i need to change? Can I keep my version of mySql that came with phpdev423.

    Many thanks,

    Mark

    Originally posted by omiossec
    First make sure that innodb is configured on your server then you can alter your table by using alter table type = innodb

  4. #4
    Join Date
    Oct 2003
    Location
    Slovakia
    Posts
    482
    Originally posted by ypx5269
    Hi,

    Being new to this could you explain where I have to configure this. How do I get to the files and what lines do i need to change? Can I keep my version of mySql that came with phpdev423.

    Many thanks,

    Mark
    You probably using MySQL 4 - classic. There is not InnoDB included!
    For InnoDB use the Standard or Max version of MySQL.

    Info about InnoDB configuration you can find in your my.cnf file.

  5. #5
    Join Date
    Sep 2003
    Posts
    35
    Ok,

    Thanks for the reply

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •