Re: Innodb file question
Posted by:
dhantzis
Date: June 16, 2005 04:00PM
please substitute "innodb database" with "innodb table" above. Upon some further review, it appears the .frm (defines dbase structure) & .myi (defines indices) files are still required for the database to run properly. the ibdata1 / ibdata2 files contain the data portion of the innodb tables, which can include tables in multiple databases. So unlike with MyISAM, you can't just move the database directory to a new server and have it run properly (granted similar platform and mysql version #).
Subject
Views
Written By
Posted
3052
June 16, 2005 03:00PM
Re: Innodb file question
2181
June 16, 2005 04:00PM
2000
August 05, 2005 10:49PM
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.