Author Topic: Databse (Read 1820 times)

fzrhusker1 · July 10, 2009, 12:34:45 pm

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.

Will this mess up any of my current data if I have my host do it and will I need to reinstall.

This message appears at the top of the Administer Civicrm page.

CiviCRM 2.2.7.

Joomla is 1.5.6

MySQL Version
5.0.45

Pretty new to all of this so i don't want to proceed any further with any data just in case it may get lost.

Thank you for any help.
Perl Version
5.8.8
PHP Version
5.2.5

ken · July 11, 2009, 04:57:36 am

You need to have a test environment where you can make this change without fear. Once you get it sorted there you can apply it to your real site.

(Do this even if you have a third party do it for you. That way YOU remain in control of your data ... if you can't afford to lose data then protect it. Have the third party apply the change on a test environment, and when you're satisfied, have them repeat the change on your real site.)

For pointers, try searching this forum, and also googling for "MySQL convert MyISAM InnoDB".

Ken

fzrhusker1 · July 11, 2009, 10:57:01 am

Ok this is a brand new install and there is not data in it yet. I won't input anything until its up and running and fully tested. Under MySQL with my host the only DB that is shown is the one for My Joomla install for my web site. Should there be a separate DB for Civic CRM or does it integrate with the Joomla DB for my website. I am new to most of this and I did look up converting the DB but that is way over my head. What DB am I supposed to convert, does CivicCRM have its own and if so where would I find it. If it is the Joomla DB will it mess up my website if I convert that DB.

fzrhusker1 · July 11, 2009, 01:21:57 pm

Maybe this question belongs somewhere else but I will ask it here as it has to do with integration, and cross referencing DB. My current site uses Joomla and Fireboard and when a new user registers for the site they are automatically signed up for and logged in the forums when they sign into the site. Will or does CivicCRM work in the same way. If some one signs up for a membership does it have the ability to migrate them to all user permissions they are allowed across the site. I really want to use your software but it ease of initial setup up is becoming daunting. I want my site users not to have to do much in order to use the site.

ken · July 12, 2009, 09:40:12 pm

Try looking at http://forum.civicrm.org/index.php?topic=6575.0 and http://forum.civicrm.org/index.php?topic=5292.0

In my database, the Joomla! tables (jos_*) are MyISAM and the CiviCRM tables (civicrm_*) are InnoDB. (These are all stored in the one database.) So you don't have to convert your Joomla! tables to InnoDB.

Ask your hosting provider whether InnoDB is supported. If not, then ask them to turn it on, then uninstall CiviCRM and then reinstall CiviCRM (you say you have no data in Civi so no harm done). I suspect that the CiviCRM tables will be created as InnoDB.

fzrhusker1 · July 14, 2009, 08:35:26 am

Thank you

CiviCRM Community Forums (archive)

News:

Author Topic: Databse (Read 1820 times)

fzrhusker1

Databse

ken

Re: Database

fzrhusker1

Re: Databse

fzrhusker1

Re: Databse

ken

Re: Databse

fzrhusker1

Re: Databse