Clear the Database from Backbone's Data

Backbone stores its configuration and the paired issues information inside the main database of Jira. This article describes how you can clear your database in case you uninstalled Backbone or you want to remove the synchronizations before you startup a development environment.

Before You Start

These steps are irreversible. Think about backing up your database before you move on.

Prerequisites

Make sure you meet the following criteria before you begin:

• You have access to a database user which has the permissions to delete data via TRUNCATE commands.

• You have a database client or command line interface which you can use to perform SQL commands.

How to Clear the Database from Backbone’s Data

1. Open your database client or command line interface

2. Login with the database user who has deletion permissions

3. Empty all the Backbone tables using the following commands:

   SQL

   TRUNCATE "AO_A912D8_REMOTE_COMMENT" CASCADE;
   TRUNCATE "AO_A912D8_REMOTE_ATTACHMENT" CASCADE;
   TRUNCATE "AO_A912D8_SYNC_INFORMATION" CASCADE;
   TRUNCATE "AO_A912D8_CONNECTOR_CONFIG" CASCADE;
   TRUNCATE "AO_A912D8_PROFILE_CONFIG" CASCADE;
   TRUNCATE "AO_A912D8_TENANT_CONFIG" CASCADE;
   TRUNCATE "AO_A912D8_APPLICATION_CONFIG" CASCADE;
   TRUNCATE "AO_A912D8_GLOBAL_SETTINGS" CASCADE;
   TRUNCATE "AO_A912D8_AUDIT_TRAIL" CASCADE;
   TRUNCATE "AO_A912D8_ACTIVE_BB_NODE" CASCADE;
   TRUNCATE "AO_A912D8_DEFAULTS" CASCADE;

4. Now the tables are empty and you may start with a clean state of your Backbone database again.

These statements were written for PostgreSQL. For other database types, you probably need to remove the CASCADE keyword and switch to backticks for the tablename (mysql).