Aktifkan innodb pada database server

 

login sebagai root

 

root@adpit:~# mysqladmin variables | grep have_innodb

| have_innodb                             | NO                                                                                        |

 

root@adpit:~# vim /etc/mysql/my.cnf

skip-bdb

#

# * InnoDB

#

# InnoDB is enabled by default with a 10MB datafile in /var/lib/mysql/.

# Read the manual for more InnoDB related options. There are many!

# You might want to disable InnoDB to shrink the mysqld process by circa 100MB.

#skip-innodb <-- tambahkan ini.

#

# * Security Features

 

root@adpit:~# /etc/init.d/mysql restart

Stopping MySQL database server: mysqld.

Starting MySQL database server: mysqld ..

Checking for corrupt, not cleanly closed and upgrade needing tables..

 

root@adpit:~# mysqladmin variables | grep have_innodb

| have_innodb                             | YES    

 

Selesai by carauntuk.com