Re: ibdata files

[Peter Zaitsev]

On Sat, 2004-07-17 at 15:35, Asif Iqbal wrote:

> > Especially for 1.5K the safest way would be to dump by mysqldump,
> > restart with clean database and reload it back.
> > 
> 
> Even with my ibdata tablespaces with size 5 gig?
> 

If you have only few KB of your tablespace used - yes. 
mysqldump does only actual data dump, it does not care about space
allocated but never used.


-- 
Peter Zaitsev, Senior Support Engineer
MySQL AB, www.mysql.com