Any chance of seeing a multisite option for installing a duplicate of another database? I only ask because I work a lot in creating a base state for a drupal site that has everything customized and set up user wise "out of the box" (aka .sql dump of a good state of a drupal site) and would loooove to replace our infrastructure with this type of a setup where one site can create (essentially) a copied version of another w/o setup. Also could empower our faculty to setup a "clone of john doe's course that I really like!"

Comments

schuyler1d’s picture

schuyler1d CreditAttribution: schuyler1d commented

Another group and Columbia made a module for internal use that worked like this. Unfortunately, the work was a little too specific, to generalize or incorporate easily into multisite_manager.

That said, I agree it's a great idea, and would be MUCH easier than making profiles. I see a couple of issues, but most are surmountable:
1. to be safe in a multi-prefix single DB setup, there'd need to be some clever regex on the .sql file. It might be difficult enough, that the option simply isn't offered in this environment
2. Things like the {sequences} table need to be updated appropriately (in the 5.x version, that is)
3. After tweaking, need to figure out how to run update or similar to update {system} table.

That 3rd one might be the doosy, but also be a killer feature. I'll accept a patch :-) Otherwise, I'm in the middle of the annotations work, still, so I could go in this direction, but it might be a month or two.

sindhujavn’s picture

sindhujavn CreditAttribution: sindhujavn commented

my requirement : i have my database dump in site.sql..i have to write a code in installation profile that wil read this dump and update all queries in my current db while installin... help me out to solve this.... thanks in advance...

schuyler1d’s picture

schuyler1d CreditAttribution: schuyler1d commented

@sindhujavn: this feature is unimplemented for Multisite-manager. If you need general SQL help, then there is a lot of documentation on the internet. To interface in drupal, lookup db_query() API. Also, looking at sample installation profiles might help as well. good luck.