Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

Restore a Confluence Site from a MySQL Backup

Luis Mayora1
Luis Mayora
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
April 1, 2013

Hi,

By mistake i forgot to backup my confluence site properly(not at work of course) but i would like to restore the site by using one of the mysql backups that currently have.

Is this possible since i dont have the regular xml backup file i think i can't. Any options that i could try

Answer
Watch
Like Be the first to like this
850 views

1 answer

0 votes
Bruna Griebeler
Bruna Griebeler
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
April 1, 2013

Sure. Just import your backup to a new database.

After that, point your confluence to this database on your <confluencehome>/confluence.cfg.xml.

View More Comments
Luis Mayora1
Luis Mayora
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
April 3, 2013

will try this soon.

Like
Harry Chan5
Harry Chan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
April 3, 2013

Do note that if you don't have a backup of the Confluence home and changes have been made to e.g. attachments, these would be lost.

Like
RianA
RianA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
April 3, 2013

In addition to what Bruna said, if you don't have backup of Home directory you would lose all your attachments. Unless you stored your attachment inside database.

Like
Reply

Suggest an answer

Log in or Sign up to answer
Confluence
Confluence
TAGS
AUG Leaders

Atlassian Community Events

    See all events