View Single Post

   
  #6 (permalink)  
Old 02-28-2008, 07:34 AM
Ask Josephsen
 
Posts: n/a
Default Re: drop index gives me a "copy to tmp table"

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
Reply With Quote