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