Proper backup procedure for remote site? I know variations of this question have already been asked here, but I could not find proper information on details for a backup procedure for a remote site. I am still new to Drupal.

Assuming a host handles multiple Drupal 7 sites under a /public_html directory, using the same MySQL installation:

/public_html/my_drupal_site_1/...
/public_html/my_drupal_site_2/...
/public_html/my_drupal_site_3/...
...


I see two situations to consider: i) Drush is not installed on the remote host, ii) Drush is installed on the remote host.

Regarding i), that is, Drush is not available:


What would be the proper step-by-step procedure to backup and restore my_drupal_site_2 on the remote host from a local pc, assuming the Backup &amp; Migrate module is installed on this site?
Which part of the directory tree should be copied (eventually with FTP)?
Which part should be restored?
How to make sure only the part of the database for my_drupal_site_2 is backup and restored?
Does one need to create a database before restoring the back up?
Does one need to create an 'empty' Drupal site before restoring?


Regarding ii), that is, Drush is available, say via SSH on the remote site:


What would be the proper step-by-step procedure to backup and restore  my_drupal_site_2 on the remote host from a local pc, assuming the Backup &amp; Migrate module is installed on this site?
Is there a way to synchronize a local directory tree from the remote directory tree? The idea is to put this content under subversion or git for example.


At last, is there a all-in-one solution? Like a script that could do everything at once? Thanks.
You set a path for manual and automatic backups in Backup &amp; migrate module. You get the resulting tar.gz file using ftp to your local machine for backup. If you want to restore, from within the module you choose file to upload.
For the db backup just the generated file, for the files the /my_drupal_site_1/sites/ directory
See #2
You can create a new profile in Backup &amp; Migrate module and select which tables to backup (restore only restores what was backed up so you are ok there). Partial backup requires a lot of caution as to not forget necessary tables.
If you are restoring to an existing site NO, if it is a migration you are after YES
See #5


I think you are better of using i rather than ii, as using drush is a lot more "technical" and mistake prone.

As for you last question, yes... use Backup &amp; Migrate to create a DB backup file on the server and then get everything using FTP. Even better use CPanel or Plesk and backup Home and mySql alltogether.