Welcome to WebmasterWorld Guest from 54.242.224.250

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?

 

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members