Re: shrinking space

From: Nuno Souto <>
Date: Wed, 01 Jun 2011 20:30:15 +1000
Message-ID: <>

Nuno Souto wrote,on my timestamp of 1/06/2011 8:12 PM:
> If you are really pressed for disk space, I'd suggest:
> delete offending rows,
> export the table,
> truncate it,
> then import with ignore=y and destroy=n so that it doesn't change anything in
> the current allocation or grants, just loads rows.

Oh, my apologies:
add one step to drop any indexes on the table before importing. You do *NOT* want to import a large number of rows on a heavily indexed table, if that be the case.

Nuno Souto
in rainy Sydney, Australia
Received on Wed Jun 01 2011 - 05:30:15 CDT

Original text of this message