Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: open
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.
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.