CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • MyISAM to INNODB?
Pages: [1]

Author Topic: MyISAM to INNODB?  (Read 4447 times)

polarweb

  • Guest
MyISAM to INNODB?
April 17, 2009, 12:18:28 am
I got an error message that said-

Code: [Select]
Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in your database to InnoDB. Using MyISAM tables will result in data integrity issues. This will be a fatal error in CiviCRM v2.1.
I have looked for some documentation on how to do this exactly and I am quite a bit stumped. If anyone has any idea how to do this, I could really use some help.

Eileen

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4195
  • Karma: 218
    • Fuzion
Re: MyISAM to INNODB?
April 17, 2009, 01:11:02 am
This is what uncle google had to say

http://www.experts-exchange.com/Database/MySQL/Q_21734958.html

(scroll down - experts-exchange does show the answer if you scroll down far enough)
Make today the day you step up to support CiviCRM and all the amazing organisations that are using it to improve our world - http://civicrm.org/contribute

Sunil

  • I post frequently
  • ***
  • Posts: 131
  • Karma: 23
  • The community around a product more important than the product itself?
    • CiviCRM
Re: MyISAM to INNODB?
April 17, 2009, 01:30:51 am
Hi

refer this for convert any MyISAM tables in your database to InnoDB

http://forum.civicrm.org/index.php/topic,6575.msg29016.html#msg29016

sunil
The community around a product more important than the product itself?

dharmatech

  • I post frequently
  • ***
  • Posts: 280
  • Karma: 53
    • dharmatech.org
Re: MyISAM to INNODB?
April 20, 2009, 08:17:30 am
Quote from: polarweb on April 17, 2009, 12:18:28 am
I got an error message that said-

Code: [Select]
Your database is configured to use the MyISAM database engine. CiviCRM requires InnoDB. You will need to convert any MyISAM tables in your database to InnoDB. Using MyISAM tables will result in data integrity issues. This will be a fatal error in CiviCRM v2.1.
I have looked for some documentation on how to do this exactly and I am quite a bit stumped. If anyone has any idea how to do this, I could really use some help.

The repair tool in the DB Tools package will do this for you.

-- Walt
http://dharmatech.org
oss@dharmatech.org
801.541.8671

polarweb

  • Guest
Re: MyISAM to INNODB?
April 28, 2009, 10:49:42 am
Found out we had to upgrade hosting All together, the host didn't support it on their shared plans, we had to get VPS. Thanks anyways!
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Post-installation Setup and Configuration (Moderator: Dave Greenberg) »
  • MyISAM to INNODB?

This forum was archived on 2017-11-26.