Am Sonntag, den 30.11.2008, 21:38 +0100 schrieb Andreas Kalsch: > I have split up the sql script in two parts - 1st to create table > just > with primary keys on auto_increment fields, 2nd to alter the > populated > tables.
Be aware that an ALTER TABLE on MySQL (at least with InnoDb) always copies the table into the new strucure. If you do an ALTER TABLE ... ENGINE=InnoDb this is unavoidable. All other ALTER TABLE statements are questionable. Sincerely, Joachim _______________________________________________ dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/dev
