CiviCRM Community Forums (archive)

Now, by default my MySQL is using MyISAM.  Now CiviCRM is installed along side with Joomla 1.5. 

I obviously received this message in CiviCRM:

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.

Do I need to convert all tables in my database for Joomla to InnoDB?  If so, how will this affect Joomla?  Or will it?

Hi Dave,

Excellent.  I am testing Joomla 1.5 for an upgrade that I am working on...so this is the perfect time to discover the database item

Thanks for letting me know!

 Dump the database with mysqldump

The first step is to dump the existing database using the mysqldump utility. The dump provides a complete backup of the database in case something goes wrong, and is also used to restore it later in the InnoDB format. Make sure the application is not in use while performing the conversion.

Here is syntax use:

mysqldump --user=user --password=password --add-drop-table --databases db1 > db1.sql

Change TYPE=ISAM to TYPE=INNODB

The second step is to edit the db1.sql dump file with a text editor and Replace the table type to InnoDB. Make of copy of the dump file before you edit it in case you need to restore it later.

and for more info check this http://www.linux.com/feature/46370
OR
you can use this
<?php
$link =  mysql_connect("localhost", "mysql_user", "mysql_password");
if (!$link) {
    die('Could not connect: ' . mysql_error());
}

$result   = mysql_list_tables("DatabaseName");
$num_rows = mysql_num_rows($result);
$tablearr = array();

for ($i = 0; $i < $num_rows; $i++) {
    $tablearr[] = mysql_tablename($result, $i);
}

foreach($tablearr as $key => $table)  {
     echo "ALTER TABLE $table ENGINE = INNODB;<BR>";
}

mysql_free_result($result);

?>it will generate the mysql command for all civicrm tables
sunil

Did a quick google search and found this link which might help:

http://rackerhacker.com/2007/10/03/convert-myisam-tables-to-innodb/