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
