I just started working in Drupal multisite.

Two drupal sites share the same database (but have different prefix).

I activate Backup and migrate module in one websites' modules admin page.

If I go the other site, deactivate the module in admin page, save, then reactivate the module, I get the error :
" DatabaseSchemaObjectExistsException : The table "backup_migrate_profiles" already exists in DatabaseSchema->createTable() line 657 in /home/domain/public_html/includes/database/schema.inc.

The result is that I can't activate (or use) the Backup migrate module in the other site.

Is it a normal behaviour that the module can only be used in one site of a drupal multisite install?

Also since the two sites are similar I wanted to backup from one site into the other, to re-use views, content types, to save time. Is backup migrate good for that or is there a better alternative?

Thanks!

Comments

lyosef’s picture

lyosef commented

I have gotten the "DatabaseSchemaObjectExistsException" in almost every phase of my site development with Drupal 7. I've gotten it when trying to work with Organic Groups and with Locations. Every step of development has taken several times longer than it would have had it worked as it should. I very much regret having attempted to upgrade from Drupal 6 to 7 and my employers are very disappointed and don't understand why I am unable to do my job. If you find a solution please post it.

amitgoyal’s picture

amitgoyal commented
Status: Active » Postponed (maintainer needs more info)

I have Drupal 7.15 and Backup and Migrate 7.x-2.4 on my local system. I setup 2 sites using multisite feature, sharing the same database (but have different prefix).

I tried many times activating / deactivating / uninstalling Backup and Migrate module but didn't get this error.

@Taesto - Can you provide more information on this so that we can reproduce and fix this issue?

ronan’s picture

ronan commented
Issue summary: View changes
Status: Postponed (maintainer needs more info) » Closed (cannot reproduce)

Reopen this if it's still an issue.