[ic] Table management
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?
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
More information about the interchange-users