SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Sep 2005
    Posts
    126
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    What should I set to use InnoDB in phpMyAdmin?

    Hello,
    I have two tables, user and address.
    When a user signs up, I need to insert user general information to user table and his address into address table. - transaction concept.
    Currently I am using MyIsam table type as I used to use,
    but as I researched the transaction, many suggest to use InnoDB table type. But I can't find InnoDB type in mysqladmin.
    I am using phpMyAdmin 2.6.3 and MySQL 4.1.13
    Should I set some value in config.inc.php to use innoDB table type?

    Thanks in advance.

  2. #2
    SitePoint Wizard silver trophybronze trophy asp_funda's Avatar
    Join Date
    Jun 2003
    Location
    ether
    Posts
    4,497
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Cool

    open the table structure in phpMyAdmin & you'll notice a tab called "Operations" in the nav bar on top. click that & at the bottom of the page you'll have the option to change table type. It'll have your current engine selected. just select "InnoDB" from there & click the button to save!!
    Our lives teach us who we are.
    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    Me - Photo Blog - Personal Blog - Dev Blog
    iG:Syntax Hiliter -- Colourize your code in WordPress!!


Bookmarks

Posting Permissions

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