Gordon Burditt skrev:
> I think you can dump the data, DELETE the data (not drop the table),
> alter the table as you wish (ALTER TABLE takes very little temporary
> disk space on an empty table) then reload the data.
Sounds like the solution I'll go for - hope I cam make mysqldump work
being a windows guy

And that the mysqldump can handle 6 GB of data...
Thanks
Ask