MySQL Forums
Forum List  »  InnoDB

Re: Data file size -- Global solution
Posted by: Mayur P Vegad
Date: June 07, 2010 04:10AM


innodb_file_per_table option is best for configure table wise .ibd file instead of single innodb file for all table.

if u want to enable innodb_file_per_table then

1) add innodb_file_per_table in my.ini or my.cnf file

2) take db backup by mysql dump

3 ) create new schema

4) Restore whole backup in new schema

5) After completing restoration pls check in disk by manually in schema folder
for every table 1.frm file and 2.ibd file created.(tabnle object wise ibd file created on disk)

Options: ReplyQuote

Written By
June 02, 2010 07:24AM
June 03, 2010 09:54AM
June 04, 2010 05:37AM
Re: Data file size -- Global solution
June 07, 2010 04:10AM
June 07, 2010 04:59AM

Sorry, you can't reply to this topic. It has been closed.

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.