Manivannan,
There is no way to reduce the InnoDB main tablespace.
You can get rid (=regain disk space) of InnoDB tablespaces only if you have
innodb_file_per_table setting,
which allows you to get disk space back if you drop the table.
The best option you have to free your current shared tablespace is to do a
sql dump of the whole instance and reimport into a new one (if you need
instructions on how to run multiple mysql instances on the same server just
let me know) and then discard the old instance.
Cheers
Claudio
2012/5/21 Manivannan S. <manivannan_s@stripped>
> Hi ,
>
> I am trying to reduce the ibdata1 data file in MySQL. In
> MySQL data directory the ibdata1 data file is always increasing whenever I
> am creating a new database and inserting some data into database. If I drop
> the existing database, the table structures only dropped from the server
> but data still exist in the ibdata1 data file.
>
> How to reduce the ibdata1 file size in both LINUX and WINDOWS machine.
>
> Do you have any idea how to solve this problem. Thanks for any feedback.
>
>
>
> Thanks
> Manivannan S
>
> DISCLAIMER: This email message and all attachments are confidential and
> may contain information that is privileged, confidential or exempt from
> disclosure under applicable law. If you are not the intended recipient,
> you are notified that any dissemination, distribution or copying of this
> email is strictly prohibited. If you have received this email in error,
> please notify us immediately by return email or to
> mailadmin@stripped and destroy the original message. Opinions,
> conclusions and other information in this message that do not relate to the
> official business of SPAN, shall be understood to be neither given nor
> endorsed by SPAN.
>
--
Claudio

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.