Welcome to WebmasterWorld Guest from 23.20.6.115

Forum Moderators: open

Message Too Old, No Replies

Duplicate Schema with innoDB?

how to....

     
9:06 pm on Sep 11, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
posts:4392
votes: 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.

1:54 pm on Sept 12, 2005 (gmt 0)

Administrator

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
posts:12541
votes: 1


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 Sept 12, 2005 (gmt 0)

Senior Member

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:Sept 1, 2001
posts:4392
votes: 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 Sept 12, 2005 (gmt 0)

Administrator

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member

joined:July 31, 2003
posts:12541
votes: 1


>> duplicate schema

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