Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Table of Contents

When requested by Jiwa Support for a backup of a database these are the steps to follow

...

Create a BACPAC file for cloud / Azure hosted databases or very large databases (see instructions here Manual Backups#ManuallyCreatingaBACPACBackupBACPAC Backup(.bacpac))

Otherwise, create a manual .bak backup (see instructions here Manual Backups#ManuallyCreatingaBackupBackup(.bak))

Upload the backup

Steps to upload the database onto our FTP site:
  1. Install a FTP Client onto your computer if you haven't done yet. 
    NOTE: We recommend FileZilla which is free available from the web on: 
    https://filezilla-project.org/download.php
  2. Load up the FTP client and enter the following credentials into the login section: 
    Server: ftp://ftp.jiwa.com.au
    Username: uploads
    Password: uploads

     

    Info
    titleWrite-Only permission

    The credentials used to upload files have write-only permission. Your data is secure and cannot be viewed, downloaded or deleted by anyone other than Jiwa staff.


  3. Browse to the backup file you have created and then upload it
  4. Wait until the backup is fully uploaded
  5. Update your Jiwa Helpdesk case to inform us that the uploaded file is available for us to download.  We'll then remove it from the FTP site 

Troubleshooting

Break it down

If your file is greater than 1GB, please break it up into smaller components for upload

  1. Right-click on your .bak file and select Add to archive

Image Added

2. In the General tab of winrar, type in 300 in the 'Split to volumes, size' box

3. Select MB from the dropdown, then click OK

Image Added

Set up Filezilla

If you are having trouble connecting to our FTP site

...

 via Filezilla, try these connection options:

Using Site Manager (top left icon on menu bar):

  • on the Transfer Settings tab, set Transfer mode to Active

Image Added

  • on the General tab, set the Encryption to Only use plain FTP

Image Added

Filter by label (Content by label)
showLabelsfalse
max5
spacesJ7UG
showSpacefalse
sortmodified
reversetrue
typepage
cqllabel = "general" and type = "page" and space = "J7UG"
labelsgeneral

...