[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