Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    26

    Unanswered: How to change default table type in mysql

    Hi All:

    Please note that I have installled MySQL 4.0 and want to get default table type as Innodb .

    what I should do to achieve this.

    Thanks,

    _ravi

  2. #2
    Join Date
    Sep 2002
    Location
    Montreal, Canada
    Posts
    224
    Provided Answers: 1

    Re: How to change default table type in mysql

    Originally posted by ravishankar
    Hi All:

    Please note that I have installled MySQL 4.0 and want to get default table type as Innodb .

    what I should do to achieve this.

    Thanks,

    _ravi
    Read the online doc?

    Command line option (server)
    --default-table-type=type


    http://www.mysql.com/doc/en/Command-line_options.html

  3. #3
    Join Date
    Sep 2003
    Posts
    26

    Re: How to change default table type in mysql

    Thanks for replying,
    I have already executed the command line option but still the defaukt type are innodb.

    I want to share one more issue with you:

    Please note that while upgrading to mysql 4.0 from mysql 3.23.
    I downloaded all the mysql 4.0 rpms from the mysql site and run those rpms.But while doing this by mistake I have not uninstalled 3.23 version and also it was running when I was installing the mysql 4.o.

    Please suggest me what might have went wrong because of this.

    Now when I am looking in to version of mysql it is cominng as 4.0.15 .

    Please suggest what are the steps one should follow if some one wants to upgrade to 4.0.15 because on mysql site they are advising to run few scripts to change grant etc,but no where it is mentioned ho to install mysql 4.0 when already 3.23 exists.

    Is because of above I am not able to change default table type.

    Also suggest hoe to execute command line option I might not be doing that correctly.

    Originally posted by bstjean
    Read the online doc?

    Command line option (server)
    --default-table-type=type


    http://www.mysql.com/doc/en/Command-line_options.html

Posting Permissions

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