[ic] Table management

Andrew Baerg andrew at pullingshots.ca
Sun Sep 25 20:39:11 UTC 2016

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.


> 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 

More information about the interchange-users mailing list