Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-31165

MySQL engine conversion tool does not work with mysql 5.5

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.1.4, 2.2.1, 2.3
    • Fix Version/s: 2.1.5, 2.2.2
    • Component/s: Database SQL/XMLDB
    • Labels:
      None
    • Environment:
      Linux 3.1.2
      PHP 5.3.8
      Mysql 5.5.19
      Apache 2
    • Database:
      MySQL
    • Testing Instructions:
      Hide

      1/ install moodle on mysql 5.5 forcing myisam via dboptions in config.php $CFG->dboptions = array('dbengine'=>'MyISAM');
      2/ try conversion to innodb

      Show
      1/ install moodle on mysql 5.5 forcing myisam via dboptions in config.php $CFG->dboptions = array('dbengine'=>'MyISAM'); 2/ try conversion to innodb
    • Affected Branches:
      MOODLE_21_STABLE, MOODLE_22_STABLE, MOODLE_23_STABLE
    • Fixed Branches:
      MOODLE_21_STABLE, MOODLE_22_STABLE
    • Pull from Repository:
    • Pull Master Branch:
      w03_MDL-31165_m23_innodbconv

      Description

      When I try to run mysql_engine.php --engine=InnoDB I got 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = InnoDB' at line 1'

      The reason is, that I have MySQL 5.5 and it doesn't support "TYPE" table option. We have to use ENGINE option instead, but I don't know where to set it.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  12/Mar/12