MySQL Forums
Forum List  »  InnoDB

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

Hi

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


Subject
Views
Written By
Posted
5927
June 02, 2010 07:24AM
1835
June 03, 2010 09:54AM
1468
June 04, 2010 05:37AM
Re: Data file size -- Global solution
1613
June 07, 2010 04:10AM
1873
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.