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
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