homepage Welcome to WebmasterWorld Guest from 54.205.236.46
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
Duplicate Schema with innoDB?
how to....
txbakers




msg:1579594
 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?

Thanks.

 

coopster




msg:1579595
 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.

txbakers




msg:1579596
 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.

coopster




msg:1579597
 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?

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved