Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


How can i restore my old database?

Holger Klatt
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
Oct 06, 2023

Our company bought the atlassian-confluence-7.18.1 software and hosted it for round about 1.5 years on a local server.

All of a sudden confluence would not work any more. Our Dev-Ops coworker found out that the mysql driver that was used would not work anymore and he needed to update the driver that has to be found in /confluence/WEB-INF/lib.

The problem is that he only found out by reinstalling the very same version of the confluence binaries. But now we have some serious problems.

Our coworker created a backup.sql dump file to restore the old data after installing confluence again.
But confluence responds with an error saying that the database was used by another confluence and it wont allow to use this particular database.

How can we restore our confluence data? The sql dumps are our only backup data available.

1 answer

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Oct 06, 2023

Welcome to the Atlassian Community!

My guess is that your coworker created the database dump while Confluence was running, so it contains a flag that says "This database is in use by a Confluence".  So restoring the dump gives you a data set that thinks it is locked.

But there are other reasons it can happen, so I can't be sure that my guess is the actual problem.

Work your way through - this includes many possible ways to get and fix this problem, including my guess.

Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events