I have a multisite installation and have 1300 tables in the MySQL database.

I am configuring B&M to only back up the tables for the current site. There is no option to default to the $db_prefix, so I am selecting all the tables, then un-selecting the tables for the current site.

I know what the issue is, and it is really outside that of B&M, but could be resolved in a different way.

The issue is that the form POST is too long and will be malformed, so the profile is not saved. This can be verified as any other changes to the profile are also not saved and the profile reverts to the default values.

Two options:

  1. Add support for $db_prefix so that the current database is the only one backed up. I think this would benefit B&M anyway as it would allow the exclusion of non-drupal tables in a single site database too.
  2. Allow the selection of tables by prefix. Present a listbox of unique prefixes and allow the user to select. This will submit a much shorter list when the form is submitted and not cause the POST to fail.

I have tried this in both 6.x-2.6 and 6.x-2.x-dev, as I read a post somewhere that the dev version had added support for $db_prefix but I could not see it.

Without this capability it is impossible to backup a single site on a large multisite installation.

Cheers,

Roy

Comments

pglatz’s picture

I'm experiencing this problem with a single site installation; I'm trying to store the watchdog table, but when I remove it from the exclude list and submit, it is still excluded.

malc_b’s picture

I think this

https://drupal.org/node/909486

is the same problem. The above thread has a patch in case anyone wants to try it. I won't have the time for the next week.

ronan’s picture

Status: Active » Fixed

Patch from the listed issue has been committed.

Thanks

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.