[ic] Table management

[Grant]

>> 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?