MySQL Forums
Forum List  »  InnoDB

Re: tranffer innoodb files
Posted by: Rick James
Date: January 08, 2015 06:57PM

> are the SAME carousel_press files (based on size)

Not necessarily. Look in my.cnf; you probably see
innodb_log_file_size = 5M
(or it is not there, and merely defaulted) The two log files will always be that size, regardless of what is in them (which could be 'nothing').
Similarly for ibdata1, except that it probably says "autoextend" meaning that it starts at some size and grows.

Note that a fresh install (no data) will build the pair of log files and ibdata1 based on the sizes in my.cnf, but there will be 'nothing' in them. This was part of the 6-step process I gave you.

InnoDB needs those files; MyISAM ignores them.

I gave you a clumsy 6-step process to attempt to get the _data_ from ibdata1 for the InnoDB tables. Is that the goal?

Or is the goal to simply use the MyISAM tables? You seem to have a copy of them in the database/directory `save_cp`.

Options: ReplyQuote


Subject
Views
Written By
Posted
1739
January 04, 2015 06:05PM
1011
January 06, 2015 01:11AM
995
January 06, 2015 10:07PM
1204
January 07, 2015 07:07PM
1036
January 07, 2015 09:34PM
Re: tranffer innoodb files
1052
January 08, 2015 06:57PM
1058
January 08, 2015 09:05PM
1011
January 09, 2015 06:03PM


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.