homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderator: open

Databases Forum

Duplicate Schema with innoDB?
how to....

 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?

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.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved