stickyimage

Felici is packed with a cool notification manager, alert your visitors the smart way.

Learn More Close

Enabling InnoDB for cPanel Usage

by on April 22, 2010 with 2 Comments in Howto

I was importing a database dump today where I encountered an error:

  • MYSQL error 1071

A  friend came and looked into the problem, he concluded that I need InnoDB to solve this problem.

But how do I activate INNODB for cPanel?

1- What I have:

  • VPS (Virtual Private Server) www.maxserv.nl
    • Shell root access
  • WHM/CPanel (cPanel 11.25.0-R44718 – WHM 11.25.0 – X 3.9)

2 – Activating InnoDB

  1. Login into you VPS with SSH and root
  2. Open the following file

nano /etc/my.cnf

  1. Find the following line and comment it out.
    1. skip-inndob

[mysqld]
#skip-inndob

Now login into you WHM

http://domain/whm

Go to

  1. Restart Services
  2. Click on: SQL Server (MySQL)
  3. Then confirm the process with a “Yes”

All of these steps should activate the InnoDB module, you can test it by going into your phpMyAdmin > SQL

Enter: show engines; command into the empty field and press <Start>

It should give the output:

InnoDB YES Supports transactions, row-level locking, and fore…
www.maxserv.nl
1154 days ago by in Howto. You can follow any responses to this entry through the | RSS feed. You can leave a response, or trackback from your own site.
About

Just a man in Linux and Windows!

Related Posts

2 Comments to Enabling InnoDB for cPanel Usage

Leave A Response

Required

CAPTCHA Image

*

Spam Protection by WP-SpamFree