[ic] Table management

Grant emailgrant at gmail.com
Sun Sep 25 02:25:14 UTC 2016

How do you guys manage your mysql tables?

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

More information about the interchange-users mailing list