List:Database Benchmarks« Previous MessageNext Message »
From:Peter Zaitsev Date:July 12 2004 9:47pm
Subject:Re: ibdata files
View as plain text  
On Thu, 2004-07-08 at 18:27, Asif Iqbal wrote:
> Hi All
> I have two ibdata files together are taking 5 gig disk space. Here is
> the setting in my.cnf file
> innodb_data_file_path = ibdata1:1882M;ibdata2:10M:autoextend
> What would be the safest way to clear the ibdata files without
> corrupting my database which is only 1.5K in size

Especially for 1.5K the safest way would be to dump by mysqldump,
restart with clean database and reload it back.

Peter Zaitsev, Senior Support Engineer

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