Duplicate Schema with innoDB?

how to....

[txbakers]

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]

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]

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]

>> duplicate schema

OK, how about using mysqldump, search/replace the text file created to modify the SCHEMA, then run it to restore the tables?