given that my table is in myisam, there are some hacky way of doing this (referred to this online) like creating table without keys, insert data from .myd, copy of .frm, .myi files for same table created with keys, and then doing a repair table on new table..
but i was wondering if there is an easy way to do it. On Wed, Apr 16, 2008 at 5:30 PM, Arun Kumar PG <[EMAIL PROTECTED]> wrote: > hi, > > is there any other best way add a new column to an existing table having > 60+ million records. alter is taking more than 1.5 hours.. what are the best > practices around this. quick help will be appreciated. > > -- > cheers, > > - a -- cheers, - a
