|Project:||Backup and Migrate|
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.
- 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.
- 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.