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
MySQL AB, www.mysql.com



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