I am unable to create tables in my MySQL database.

Some programs, including the MySQL Query Browser recommended above, use the INNODB engine by default to create tables in a MySQL database.

Our servers do not support this type of engine. You therefore need to specify a different storage engine.

If you are using the MySQL Query Browser software, you simply need to select Table options and the MyISAM storage engine.

This type of engine is much more secure and reliable than the INNODB engine.

If instead you are using the SQL code to create tables, you can specify the type of engine directly in the code.

Here is an example:

  CREATE TABLE `users` (
    `id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
    `name` VARCHAR(45) NOT NULL DEFAULT '',
    `surname` VARCHAR(45) NOT NULL DEFAULT '',
    PRIMARY KEY(`id`)
  )
  ENGINE = MYISAM
  CHARACTER SET utf8 COLLATE utf8_general_ci;

back