Managing Accounts (FTP, SQL, Site) - SiteVault Wiki Documentation, website backup

Home Wiki Purchase Downloads FAQ's Customers Support Community Contact Send to a colleague       Wiki Categories: Useful Information About SiteVault » Video Tutorials 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 » Complete SiteVault Details MySQL Backup FTP Backup SiteVault Software Details Backup MySQL Database Backup for Webmasters 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 Setting an SQL Account Setting a Site 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. « Back to Categories Home | Your Account | Downloads | Purchase | Wiki | Affiliates | Freeware | Support | Contact | About Us Copyright © 2005 by Amorphys Design