Re: Data file size -- Global solution
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)
Subject
Views
Written By
Posted
6138
June 02, 2010 07:24AM
1955
June 03, 2010 09:54AM
1630
June 04, 2010 05:37AM
Re: Data file size -- Global solution
1720
June 07, 2010 04:10AM
3071
June 09, 2010 01:31AM
2057
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.