how import a mysqldump without ENGINE specified in MyISAM

Question

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?

score 3 · Accepted Answer · answered May 07 '12 at 17:50

3

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

default-storage-engine=MyISAM

answered May 07 '12 at 17:50

rid

score 1 · Answer 2 · answered May 07 '12 at 17:51

According to the docs, you can:

start the server with a specified default storage engine:

You can specify the default engine by using the --default-storage-engine server startup option,
change the config file

or by setting the default-storage-engine option in the my.cnf configuration file.
change the engine on a session by session basis

You can set the default storage engine to be used during the current session by setting the default_storage_engine variable

2 Answers2