Managing Accounts (FTP, SQL, Site)

Jessica is typing a message...

newsletter

Wiki

Useful Information About SiteVault - SiteVault Wiki Documentation

Interface Overview

Managing Accounts (FTP, SQL, Site)

Backup Your Data

Restoring Sites

Cleaning Unneeded Backups

FTP Advantages

SQL Advantages

Export-Backup Databases with a Simple Copy/Paste

The Properties Window

Change the Backup Folder

The Shorcuts List for SiteVault

The Icon List of SiteVault

More Information On SiteVault - SiteVault Wiki Documentation, website backup

Complete SiteVault Details

MySQL Backup

FTP Backup

SiteVault Software Details

Backup MySQL Database

Backup for Webmasters

social links

Find us on:

» Wiki

Managing Accounts (FTP, SQL, Site)

Usually you will keep more than one site on the same web host. In this case SiteVault becomes invaluable.

First you specify the FTP Account for your site followed by the SQL Account. After that each Site is defined as:

a folder on your FTP Account
a database (or a collection of tables) from the SQL Account

Any one of these two is optional. You can have a Site without an SQL Account or you can skip the FTP Account if you are only interested to Backup/Restore your database.

Setting an FTP Account

In order to access your site's files SiteVault contains a FTP client.
You may create as many FTP accounts as you want and can have them connected at the same time as well.
Note: Some site hosts will not allow multiple connections from the same IP address.

Caption	The caption of the FTP Account. It will help you identify your account.
Host	The FTP server's name/IP you wish to connect to.
Port	The port on which the FTP server is listening for connections. The default value is 21 (Optional).
Username/Password	The username and password to communicate to the FTP server for authentication.
FTP Root	Once connected to the server a you start from a path specified by the FTP server. Here you can specify a different start path (Optional).

Press the Wizard button at any time to switch between Normal and Wizard Mode.

Setting an SQL Account

This can be a bit tricky until you understand how it works. But after that it will only take you a Copy/Paste (or Backup command) to Export/Backup your databases.

So here's how:
• In order for SiteVault to backup your database(s) some scripts must be uploaded to your FTP account (because most hosts will not allow connections to the SQL server from another IP).
• Then SiteVault will use them to Backup/Restore your database(s) through the HTTP protocol.
• We recommend you to create a special folder for them ex: "/public_html/backup-scripts".
• You must make sure that the scripts will be visible for the Web. Ex: http://www.your-site.com/backup-scripts

Caption	The caption of the SQL Account. It will help you identify your account.
Database/Script	The database server type and the script type that your server supports.
Script parameters for connection	The parameters you use in your scripts (PHP, ASP etc…) on the site to connect to the SQL server.
Username/Password	The username and password required to connect to the SQL server.
Host	The host is usually "localhost" because the SQL server is usually on the same computer as your site's scripts. If it is a different one please specify.
Port	The default port is usually the right one but if your SQL server listens on a different port please specify it.
Where to upload the scripts	The scripts that will Export/Backup/Restore your databases can be placed automatically to your site by specifying an FTP account and a folder where to place the scripts. If you intend to place the scripts manually you can skip the "FTP Account" and "FTP upload path". Regardless of how you upload the scripts you must specify a valid HTTP URL that will point to the directory where the scripts are placed. For example: if the FTP folder where you placed the scripts is "/public_html/backup-scripts" the "HTTP scripts URL" will be http://www.your-site.com/backup-scripts
FTP Account	The FTP Account to use to upload the scripts automatically.
FTP upload path	The FTP path where to place the scripts
HTTP scripts URL	SiteVault must use these scripts with the HTTP protocol. So a valid URL that will indicate the folder where the scripts are placed is required
"Show scripts" button	Will open the folder where the scripts are so you can upload them manually.
"Upload scripts" button	Will attempt to automatically upload the scripts to the specified FTP folder using the selected FTP Account. If the specified folder does not exists it will be created.
Database selection mode	Because (in most cases) you share an SQL server with other people the SQL function that shows the list of all databases on that server is not allowed. If this is the case you will have to specify your databases manually. Select the "Manual" option and start adding databases one by one (Type the database name in the textbox and press the "Add" button)

Press the Wizard button at any time to switch between Normal and Wizard Mode.

The scripts do not represent a security threat because they do not contain the username and password required to connect to the SQL server. The information needed to connect will be sent to the scripts each time they are needed through GET/POST.
Note: If you need additional security you can restrict access to the scripts and only allow requests from your IP(s). Place the scripts in a separate folder. Create a ".htaccess" file and add these lines to it:

#begin .htaccess file
Order deny,allow
Deny from all
Allow from your-domain-or-ip.com
#end .htaccess file
For additional information on security issues for Apache HTTP servers go to http://httpd.apache.org/docs/2.0/howto/auth.html
Or contact us at support@site-vault.com

Setting a Site

A Site is defined as a folder on your FTP Account and a database (or a collection of tables) in an SQL Account. Any one of these two is optional.
You can have a Site without an SQL Account or you can skip the FTP Account if you are only interested to Backup/Restore your database.

Caption	The caption of the Site. It will help you identify your Site
FTP Account	The FTP account for the Site.
FTP Path	The FTP path for the Site. This will specify the FTP folder that will Backed up/Restored.
Backup FTP-HTTP equivalence	Sometimes an FTP request for a file will return "Access denied" (regardless what FTP client you are using). Most likely because an image (or other file) had been uploaded with a script and the permissions for that file have not been set correctly (at all) by the script. If this is the case SiteVault can attempt to get the file using HTTP. For this SiteVault needs to know the equivalence between the FTP path and the HTTP path. For example: if your Site is placed in the FTP folder "/public_html/" the HTTP equivalent path is http://www.your-domain.com/
Specify SQL Account, Database and tables to backup	Select the SQL Account and then the database that contains the tables for this Site. If all the tables in the database are needed for this Site just leave the "Use All tables" check box checked. If not, uncheck the check box and start selecting tables from the list (hold the CTRL or ALT key pressed)

Press the Wizard button at any time to switch between Normal and Wizard Mode.

	Contact us	Amorphys Development
Constantin Severeanu 12 St., Bucharest, Romania

Phone:	040 722 856 389
Email:	support@site-vault.com
Contact form: