Search code examples
mysqlmyisammysqlimport

how import a mysqldump without ENGINE specified in MyISAM

all my sqldumps are without the "Engine=..." syntax in the CREATE Statements, so maybe i can somehow add "ENGINE=MyISAM" to the default import?

because on my ubuntu 12.04 server with mysql 5.5 importing a large table is very slow, because it is using the standard InnoDB when i just import it

or can i set a settings flag in mysql, that new tables created are MyIsam as default?

Solution

  • To set the default engine to MyISAM, use the following configuration option in my.cnf:

    default-storage-engine=MyISAM