MySQL Forums
Forum List  »  InnoDB

Re: tranffer innoodb files
Posted by: Gene Meyers
Date: January 06, 2015 10:07PM

My database is called carousel_press. Before I contacted you, I had started recreating the database (using MyISAM this time). I had also tried using the saved innodb files before that. So the MySQL data directory looked like:

directory carousel_press (contains all the new MYI, MYD,frm files
files ibdata1, ib_logfile0, ib_logfile1 (the onew I tried to recover).

So in following your instructions, I did:
1) Moved the ibdata1, etc. files to a save place (not in the data directory)
2) created a new database named save_cp with save structure as the myISAM version of carousel_press
3) inserted all data from carousel_press into corresponding tables of save_cp
4) DROP database carousel_press
5) stopped mysqld
6) restarted mysqld
The old ibdata1, ib_logfile0, ib_logfile1 appeared in the MySQL data directory. Why did this happen--is there still some reference to thewm somewhere?

I did SHOW DATABASES but carousel_press does not appear in the list.

Hopefully you can unravel this. Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
1739
January 04, 2015 06:05PM
1011
January 06, 2015 01:11AM
Re: tranffer innoodb files
995
January 06, 2015 10:07PM
1204
January 07, 2015 07:07PM
1036
January 07, 2015 09:34PM
1053
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.