List:Database Benchmarks« Previous MessageNext Message »
From:Peter Zaitsev Date:July 19 2004 4:44am
Subject:Re: ibdata files
View as plain text  
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

ibdata filesAsif Iqbal9 Jul
  • Re: ibdata filesPeter Zaitsev12 Jul
    • Re: ibdata filesAsif Iqbal18 Jul
      • Re: ibdata filesPeter Zaitsev19 Jul