Re: Using per table tablespace option

[Rafal Kedziorski]

development wrote:
> Hello all,
>
> As i've posted the message before few hours, I've
> partially got the answer of my problem. If i m not
> wrong then for innodb tablespace once we've
> allocated space for ibdata then we cant shrink the
> file ibdata although we are dropping some tables
> or deleting so many rows from the tables.
>
> now i've got the solution to use per table
> tablespace option. I wanted to ask that if i am
> enabling innodb_file_per_table option in my.cnf
> file and restarting the mysql server, all the
> newly created table will create new .ibd files,
> but what can i do for my old tables to make the
> same .ibd files and shrinking my actual ibdata
> file??

I think the best way is to export your old tables, remove them and import the exported data. Than MySQL would create the new tables with file per table.

Regards,
Rafal