Downloading your site’s database

Once you have migrated, your temporary site is hosted on our server. The purpose of the site that is provisioned for you is to let you organise and customise your migration; it’s for temporary use only. We recommend that you deploy this migrated database to your own environment as soon as possible after migration.

To download the database of your site as a compressed sql file, click Download > Database > Download. To download the database of your site as a compressed sql file. This option is only available after you have migrated the site as a subscribed user.

You can then host this database on your own server or engage with the govCMS team to explore other hosting options.

Downloading your file list

To reduce migration time, the Workbench doesn’t migrate your physical files (i.e. images and documents). It simply creates placeholders and database entries for them on your provisioned temporary site. Once you have downloaded the database and hosted it on your own server, you need to place the physical files in your new site yourself.

To download a list of the physical files you have on your website, click Download > File List > Download File List. This option is only available as a subscribed user. Downloading the file list will export information about all your files into a CSV file, which can be used to download the physical files so you can place them in your own site.

The exported CSV file has two columns:

URL: The source URL of the file. This URL will be used to download the file.

File Name: The name of the file. This name is the required name in the Drupal site, which may not be the same as the original file name.

In order to download the physical files based on the file list, you can download the shell script we provide and execute it with the CSV file. For Windows users, the script works with Linux-like environments like Cygwin or Git Bash. To execute the script:

  1. Download the shell script.
  2. Open a terminal from the folder contains the downloaded script file.
  3. In the terminal, type the command in the following format:
./download.sh [PATH_TO_CSV] [PATH_TO_TARGET_DIR]

Please note that you need to replace the two arguments in the square brackets with the real path in your environment.

The first argument is the path of the file list file you downloaded from the Workbench.

The second argument is the path of the directory where you want to keep the downloaded files.

You can then copy the files to your own environment. You can also add local files into this folder manually.

Tip: For more information about the Content Workbench, make sure you look at the Exporting/Importing Documentation and the Rules Documentation.