| Welcome to WebmasterWorld Guest from 22.214.171.124 |
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
|Pubcon Platinum Sponsor 2014|
|Duplicate Schema with innoDB?|
| 9:06 pm on Sep 11, 2005 (gmt 0)|
With myISAM tables in mySQL I can simply copy/paste the files into a new directory to create a duplicate schema.
With INNODB tables I can't do that.
Is there a command to be able to duplicate an entire schema with innoDB tables?
| 1:54 pm on Sep 12, 2005 (gmt 0)|
You mean like Moving an InnoDB Database to Another Machine [dev.mysql.com] or Backing Up and Recovering an InnoDB Database [dev.mysql.com]?
I've never used the commercial product mentioned (InnoDB Hot Backup) but if you don't need to backup your InnoDB database while it is running you won't need to either.
| 2:10 pm on Sep 12, 2005 (gmt 0)|
Thanks coop, but that's not what I was looking for. Let's say I have a 50 table DB called Swimwear (for my swimwear site).
I'm now ready to start a site for Sportswear and I want to use the exact same 50 tables, but in it's own schema.
With myISAM I could just copy and paste the 150 files into a new directory and the data would be there.
With innoDB I can't do that, since something is written to the ibdata1 file in binary.
I'm looking for a fast way to create the schema without having to create 50 tables again.
Maybe there is a replicate function I've missed.
| 4:03 pm on Sep 12, 2005 (gmt 0)|
>> duplicate schema
OK, how about using mysqldump, search/replace the text file created to modify the SCHEMA, then run it to restore the tables?
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved