Sites configuration

Sites configuration

If you specify a workspace, it will contain all configuration data of your websites. Site Backup Pro will automatically create a couple of XML files with your configuration data in the workspace directory (please do not delete them).

You can configure your backups via the “Configuration” tab (opened by default).

Site Backup Pro uses hierarchical configuration: You can specify hosts and sites on them. (You can add as many hosts and sites as you want to.) All of them will be displayed in the tree on the left on the “Configuration” tab.

A host item is used for configuring access to your server, that is, network addresses and security credentials for connecting to your hosting provider’s server.
A site item is used for configuring each site on the host. A site consists of an SQL database (currently MySQL and PostgreSQL are supported) and files (PHP, ASP, or JavaScript scripts, HTML files, etc.).

Configuring remote host screenshot

To add a new site, select “Add Host” in the menu or click the “Add Host” icon. A new host item with one site item will be added to the configuration. First configure the access to the server by clicking the newly created host item. You can specify the host’s name so that you can easily see what server it is.

For network access, specify the following attributes:

  • SSH host: The host name or IP address of your server
  • SSH port: The port used by the SSH server (22 by default)
  • SSH username: Unix username
  • SSH password: The password for the Unix account

You should fill all of these fields.

SSH is a secure protocol for interacting with servers. It is good both for manual actions and for automated tools, such as Site Backup Pro. For more details, read here: http://en.wikipedia.org/wiki/Secure_Shell

All transmitted data is encrypted using an asymmetrical key pair to ensure that no one but you can get your data.
Nowadays, SSH is supported by all hosting providers, even on extremely cheap hosting plans.

If you cannot find your access data for SSH, contact your hosting provider’s technical support. Web hosters usually send such information in the very first e-mail after your have registered on their site, so you may want to check your inbox.

Now, as you have configured the host item, you can go to the site item. Click on it in the tree, and you will see its configuration form on the right.

Configuring web site screenshot

Just as with the host item, enter the site item’s name and specify the following attributes:

  • Files section
    • Directory: A path to the root folder of your server files (scripts, images, etc.). Site Backup Pro supports both absolute and relative paths.
A relative path should be relative to the current shell path after you log in and run the “Before backup” commands. Usually it is the home folder of the account specified in the host item’s credentials.

You can remote file system explorer to select a directory by clicking ".." button:

Remote web site file system explorer screenshot

  • SQL section
    • Database type: MySQL or PostgreSQL, depending of the database used on the site.
    • Host: The host of the SQL server. Specify it just like it is configured on your site: Site Backup Pro will connect to the MySQL/PostgreSQL server from the SSH server, not from your computer.
    • Port: The port of the SQL server (3306 by default for MySQL, 5432 for PostgreSQL).
    • User: The user who can access the required schema.
    • Password: The password of the specified user account.
    • Schema: The schema (database) or schemas used by the site that you need to back up. If you run the backup command, you will get a full dump of the selected databases.

​​You can use SQL Schemas remote browser to select needed databases:

Screenshot of remote SQL databases dialog

The following parameters are optional but may be helpful in advanced projects.

  • Commands to Run section
    • Before backup: The commands that run right after connecting to the SSH server but before executing the backup commands. Useful for doing some pre-backup actions on the server (for example, to stop the server, restrict access to the server while a backup is running, etc.). Note: Some commands may change the current SSH directory, which may cause your directory option being incorrect if it is relative.
    • After backup: The commands that run after Site Backup Pro backs up the site, but before it disconnects from SSH. Such commands may be useful, for example, for canceling effects of the “Before backup” commands.

Every site has an On/Off switch. “On” (default state) means that the site is enabled, that is, included in the backup list when you back up all sites. This flag does not matter if you manually back up only one site.

That’s all. Site Backup Pro automatically saves configuration at certain events (making backups, exiting the program, etc.), but you also can do it manually any time by selecting “Configuration → Save” in the menu.

Now if you have entered all data correctly, you can launch the backup of your site, or add another host or site item. Of course, if you do not need some host or site item, you can easily delete it from the configuration via Site Backup Pro’s menu or toolbar. If you delete a site, its backups will not be deleted automatically, and you will continue to see them on the “Archive” tab.