DB engine for tables

[chrislynch8]

Hi,

Is it just my setup or do sugar use MyISAM for all tables except for teh accounts_cstm table. I had to restore a database recently and because the accounts_cstm was innodb and corrupt it by coping the backup in instead to using the ib_logfiles???

With the MyISAM you can copy a file backup ie a rsync, cp of /var/lib/mysql/DB and it will work, with innodb table you have to restore in issue extra command, get a sqldump in recuew mode adn the restore that to the database.

Is it possible to checge teh engine that the accounts_cstm table using without damaging the table, data and any other tables in the DB


Rgds
Chris

[stephanw]

hello,

this is related to your settings in mysql.
it looks that your default engine is set to InnoDB.

so when you create a custom table (via sugar), the default engine is choosen.

to change this, you need to change the attributes in mysql.

to change the type of the cstm table you can e.g. use phpmyadmin and change the engine in the point "operations".
that is generating an "alter table" statement.

hope that helped

stephan
www.niftybits.de