InnoDB Is Disabled By Default

Posted by Unknown at 03:22
Contrary to what appears to be claimed in the cPanel forums, InnoDB is not disabled by default on cPanel servers in later versions of MySQL 5…at least it shouldn’t be. If you get errors in your application due to InnoDB storage not being enabled, log into your MySQL console and run:
show engines;

You should see a list of all the storage engines MySQL supports, and you may see something like this:

| InnoDB     | DISABLED | Supports transactions, row-level locking, and foreign keys     |

If you do, there are generally two things that would cause this:

1. Check my.cnf for skip-innodb. If it’s there, remove that line and restart MySQL

2. Your ibdata files are corrupted. Try moving the ibdata* files out of /va
Labels: ,

9 comments:

  • family health
    4 December 2010 at 07:55

    I may recognize that you are an expert at Your field! I am launching a website soon, as well as Your New answer will be in truth helpful as me.. Gratitude being most Your support as well as wishing end users all The accomplishment to Ones Project.

  • Adeline Levandoski
    10 January 2011 at 09:37

    After read consumers homepage, I thought Ones New articles is great! I'm very like Your New content. I bookmarking A New blog! I rely on you went behave better off from Today at.

  • Reina Spence
    12 January 2011 at 13:39

    Thank you being The super contents. I am glad I have on taken The time how to recognize stuff like this.

  • Mobil Keluarga Ideal Terbaik Indonesia
    24 January 2011 at 01:40

    fantastic blog! I genuinely enjoy Techniques to it’s simple in my eyes as well as also The info could be well written. I am wondering Techniques to I may be notified when a new article has been allowed. I allow subscribed how to A New rss feed which ought to achieve The trick! allow a nice day!

  • Krysta Demas
    26 January 2011 at 00:17

    Great information.i hope you will write another good post

  • Jeanna Busskohl
    26 January 2011 at 10:49

    I discovered A New site in delicious Nowadays as well as really liked this.. i Bookmarked it and also went be rear how to evaluate it out A few way more afterwards:)

  • Tiny Cutri
    27 January 2011 at 15:01

    Do you have twitter or facebook ? i will follow you friend

  • Admin
    27 January 2011 at 17:20

    Yes..

    http://www.facebook.com/profile.php?id=100001929683936

  • Ronda Deangeles
    29 January 2011 at 06:27

    After reading you blog, I thought Ones New article is amazing! I'm ideal likes A New content. I bookmarking Your New site! I rely on consumers will behave better from At present in.

    • Post a Comment

    Subscribe to: Post Comments (Atom)