changing bitbucket db

[venkatraj v.p.]

will we be able to change the bitbucket db from mysql to postgresql when we migrate the bitbucket server. from the link below i got to know about the dbmigration wizard.

https://confluence.atlassian.com/bitbucketserver/connecting-bitbucket-server-to-an-external-database-776640378.html#ConnectingBitbucketServertoanexternaldatabase-migration

how do we backup and restore the backup when we change the database from mysql to postgresql

[Ana Retamal]

Hi Venkatraj!

It's as easy as explained in the section 'Using the database migration wizard' from the article Connecting Bitbucket Server to an external database:

You can use the Database Migration Wizard to migrate the Bitbucket Server data:

• from the embedded database to a supported external DBMS.
• to another instance of the same DBMS.
• from one DBMS to another supported DBMS (for example, from MySQL to PostgreSQL).

You need to have created the DBMS (such as PostgreSQL) that you wish to migrate the Bitbucket Server data to before running the Migration Wizard.

To run the Database Migration Wizard:

1. Log in to Bitbucket Server.
2. In the administration area, click Database (under 'Settings').
3. Click Migrate database and follow the instructions for running the migration.

Make sure that you're migrating to a Postgres version supported on the Bitbucket Server version you're running, and that the destination database in Postgres was created by following our recommendations at Connecting Bitbucket Server to Postgresql.

Let us know if you have any more questions!

Kind regards,

Ana

[venkatraj v.p.]

hi Ana,

Thankyou for sharing the information on using the DB migration wizard. the article is clear for backing up the existing db. how do we restore/import the backup to the newly created db using the bitbucket ui

[Edwin Kyalangalilwa]

Hi @venkatraj v.p.,

The current database will stay intact. If there are any issues after the migration, you can simply point it back to your current database.

[venkatraj v.p.]

Hi Edwin,

Thanks for sharing the information. will we be able to change the bitbucket db from mysql to postgresql using the dbmigration wizard.

how do we backup and restore the backup when we change the database from mysql to postgresql.

[Edwin Kyalangalilwa]

You can backup the database and home directory. Please take a look at this document Data recovery and backups

In the file

<bitbucket-home>/shared/bitbucket.properties

To restore, you change the jdbc information in the file from the new db to the current db. For example:

jdbc.driver=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://<url>