How to enable InnoDB to start on startup

[Enzyme]

If InnoDB isn't starting up on start up then navigate to the /etc folder.

In there open up with your favourite editor, the file 'my.ini' or 'my.cnf'.

Or for short:
nano /etc/my.cnf

Once you are in there search for 'skip-innodb'.

If it is there then delete the line & restart MySQL:

/sbin/service mysql restart

CentOS.

 

[eLight]

To check if InnoDB is already running/is running after changes, in MySQL run:

show engines;

InnoDB should be in the list with no problems. Support = "YES".

 

[Enzyme]

Do you not have to type 'mysql' first? Type 'show engines;' then Pause Break to come out of 'mysql'?

 

[madaboutlinux]

Yes, show engines; need to be executed on the mysql server prompt and then come out of it.

BTW, the easy way to check if innodb is enabled is to execute the following without entering the mysql prompt

mysqladmin variables | grep have_innodb

You may need to provide mysql username/password as per your mysql configuration.

mysqladmin variables -u<user> -p<password> | grep have_innodb

 

[Enzyme]

You learn something new everyday :D.

 

[eLight]

My bad, I should have stated that was from MySQL, not bash.

 

[DoctorX]

Nice tuto...
Thanks