[ic] Table management

[Andrew Baerg]

On 25 Sep 2016 04:25, Grant <emailgrant at gmail.com> wrote:
>
> 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

>
> 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? 
>
> - Grant 
>
> _______________________________________________ 
> interchange-users mailing list 
> interchange-users at icdevgroup.org 
> http://www.icdevgroup.org/mailman/listinfo/interchange-users