MySQL Forums
Forum List  »  InnoDB

Re: tranffer innoodb files
Posted by: Gene Meyers
Date: January 07, 2015 09:34PM

1) The innodb files that automatically got created are the SAME carousel_press files (based on size) that I am tryign to recover. So the question is why, after dropping database carousel_press and after moving these innodb files to a different directory, and after shutting down mysqld, did they automatically reappear after restarting mysqld. I feel there must be some other place where these old files are referenced.

2) I created the save_cp database just to backup the smaLL MyISAM-based carousel_press database I had created last week and which has a very few entries. I didn';t want to lose those after if did deleted the carousel_press database. I CAN access the save_cp database.

The mysql data directory has this structure:
mysql - directory
performance_schema - directory
save_cp - directory containing the MYD,MUI and FRM files I backed up from database carousel_press
test - directory
Gene-PC.err - 4KB file
Gene-PC.pid - 1KB file
ib_logfile0 - 5120FB file (from backup of old carousel_press database)
ib_logfile2 - 5120 KB file (" ")
ibdata1 - 18432 KB file (" ")

Options: ReplyQuote


Subject
Views
Written By
Posted
1744
January 04, 2015 06:05PM
1014
January 06, 2015 01:11AM
1003
January 06, 2015 10:07PM
1208
January 07, 2015 07:07PM
Re: tranffer innoodb files
1043
January 07, 2015 09:34PM
1057
January 08, 2015 06:57PM
1060
January 08, 2015 09:05PM
1012
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.