I want to change from myisam to innodb.
My limesurvey 1.71+ is already in production.
Can I just change the config.php and new surveys will be innodb?
Or do I need to rebuild so to speak and make a completely new database?

Thanks
Charles

Copy your existing database, do the changes you mentioned with the backup and report back if everything works fine

If limesurvey doesn't run afterwards clear all tables of your backup and try to run the installer again.

Thanks for the reply.
After a lime survey backup via the admin tool and then a - shut down mysql, copy the raw database files...

First I just tried changing the config.php to read:

Then I created a new survey and checked it's table engine.
It was still myISAM


So I researched a bit on changing engines.
I didnt feel like typing alter commands all night, so I used a gui tool SQL Maestro.
Just a bunch of clicking and changed all the tables to InnoDB.
Made a new survey, and it is InnoDB.
Imported a survey and it's Innodb.
I think I'm good.

To prevent usage of lime survey during the changes, I did a .htaccess to redirect users to a "Down for maintenance" page.
Based off of this: www.techiecorner.com/97/redirect-to-main...rade-using-htaccess/

Thanks again for the help.
Charles

P.S.
I'll check the survey tables later on this week or early next week to see if they continue to be InnoDB.

Thanks for this detailed feedback.

Of course you always have to change the database engine manually, limesurvey won't do this itself by just setting $databasetabletype = "InnoDB";