[ic] Table management

Grant emailgrant at gmail.com
Wed Sep 28 10:11:41 UTC 2016

>> How do you guys manage your mysql tables?
> Hi Grant,
> We use the DatabaseAuto directive which I think should solve your issues.
> http://interchange.rtfm.info/icdocs/config/DatabaseAuto.html

Maybe the key there is the NoImport statement which DatabaseAuto puts
into effect for each table?  It sounds like NoImport moves table
management out of IC.

Also Andrew, I took a look at pullingshots.ca:

"I have been successfully running Interchange 5 using a stack of Plack
+ Nginx in production since February, 2016 on a busy site"

Your config is really simple.  Has anyone else tried this?  Any drawbacks?

- Grant

>> I dropped a table column via the mysql command line interface
>> recently, but subsequently exporting that table to .txt file in IC
>> showed that the column was still there.  Making changes to a
>> dbconf/mysql/*.mysql file or .txt file, deleting the associated .sql
>> file, and restarting IC to import a table can be a very slow process
>> which locks out all IC users in the meantime.  I tried using:
>> Database tablename AutoCommit 0
>> to speed that up, and it worked, but then the table didn't work.
>> Is there a best way to do this kind of stuff when you're using IC?

More information about the interchange-users mailing list