Re: tranffer innoodb files
Posted by:
Rick James
Date: January 07, 2015 07:07PM
> 4) DROP database carousel_press
> I did SHOW DATABASES but carousel_press does not appear in the list.
Well, it should not appear.
> The old ibdata1, ib_logfile0, ib_logfile1 appeared in the MySQL data directory.
InnoDB, even if you have no tables with ENGINE=InnoDB, will create those three files. Not a problem.
> 3) inserted all data from carousel_press into corresponding tables of save_cp
So, you have all the data, but it is in `save_cp`, not `carousel_press`, correct? Can you tell Carousel that that is the Database to use?
Subject
Views
Written By
Posted
1744
January 04, 2015 06:05PM
1014
January 06, 2015 01:11AM
1003
January 06, 2015 10:07PM
Re: tranffer innoodb files
1207
January 07, 2015 07:07PM
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.