Hi
I found solution for bitbucket backup https://marketplace.atlassian.com/apps/1211500/bitbucket-server-backup-client?hosting=server&tab=support
I downloaded this solution and created necessary config in backup-config.properties
I used login pass for user with admin privelegies
When running script it's fails
In bitbucket log file I see
Caused by: com.atlassian.stash.internal.backup.BackupException: An error occurred while backing up the database
at com.atlassian.stash.internal.maintenance.backup.DatabaseBackupStep.run(DatabaseBackupStep.java:84)
at com.atlassian.stash.internal.maintenance.CompositeMaintenanceTask$Step.run(CompositeMaintenanceTask.java:133)
at com.atlassian.stash.internal.maintenance.CompositeMaintenanceTask.run(CompositeMaintenanceTask.java:69)
at com.atlassian.stash.internal.maintenance.backup.BackupPhase.run(BackupPhase.java:71)
... 15 common frames omitted
Caused by: com.atlassian.stash.internal.backup.liquibase.LiquibaseDataAccessException: Failed to obtain snapshot. Database type: mysql; nested exception is liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied; you need (at least one of) the SHOW DATABASES privilege(s) for this operation
at com.atlassian.stash.internal.backup.liquibase.DefaultLiquibaseSession.getSnapshot(DefaultLiquibaseSession.java:76)
at com.atlassian.stash.internal.backup.liquibase.LiquibaseSessionThreadLocal.getSnapshot(LiquibaseSessionThreadLocal.java:49)
at com.atlassian.stash.internal.backup.liquibase.DefaultLiquibaseDao.countRows(DefaultLiquibaseDao.java:139)
at com.atlassian.stash.internal.backup.liquibase.DefaultLiquibaseMigrationDao.countTotalRows(DefaultLiquibaseMigrationDao.java:111)
at com.atlassian.stash.internal.backup.liquibase.DefaultLiquibaseMigrationDao.backup(DefaultLiquibaseMigrationDao.java:74)
at com.atlassian.stash.internal.maintenance.backup.DatabaseBackupStep.run(DatabaseBackupStep.java:82)
... 18 common frames omitted
Caused by: liquibase.exception.DatabaseException: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied; you need (at least one of) the SHOW DATABASES privilege(s) for this operation
How I can fix it?