Back Up and Restore

Super administrators (username: admin) can back up the Alteryx Connect H2 database from the Administration Console. This creates a backup.zip file of the Alteryx Connect database and saves it to the ac_work directory. The backup can then be used to restore the Alteryx Connect database.

Back Up

1. Log in to Alteryx Connect with super administrator credentials (username: admin).
2. Select your icon in the top-right of the screen and select Administration.
3. From the Admin Menu, select Export and Import, then select Export.
4. In the Database backup section, select H2 Backup.

A file called h2backup.zip is created and placed in the ac_work directory. The file contains data.mv.db.

1. Copy the h2backup.zip file to the ac_work directory.
2. Stop the Alteryx Connect service:
   1. Open the Windows Task Manager.
   2. On the Services tab, select Services.
   3. In the list of services, select Alteryx Connect.
   4. Select Stop and leave the Services window open.
3. Unzip the backup file to replace the database files in the ac_work directory.
4. In the Services window, select Start to restart the Alteryx Connect service.
5. Perform a full reindex of the database to complete the restoration:
   1. Log in to Alteryx Connect.
   2. Select your icon in the top-right of the screen and select Administration.
   3. From the Admin Menu, select Maintenance, then select Reindex.
   4. Select Full Re-index. In case you do not perform the full reindex, the Connect home page will not be displayed.