Confluence Restore failed from daily-backup

Question

Hi,

I have a problem to restore confluence with Daily-Backup-20140120.zip

You can find my error below.

Confluence : Version 3.4.8

Importation des données

Temps écoulé:5 , 14 secondsTemps restant:12 , 13 seconds (estimated)Dernière étape:30% complete

Import failed. Hibernate operation: could not insert: [com.atlassian.confluence.pages.Page#5406797]; SQL []; Duplicata du champ '5406797' pour la clef 'PRIMARY'; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Duplicata du champ '5406797' pour la clef 'PRIMARY'

Thanks for your help.

Best regard.

Marouen Bourbia · Answer

Thanks for response.

exploitationB · Answer

Hi Felipe :

Look my actions :

1 - Drop database "confluence" 
2 - Creation of database "confluence" empty 
3 - Remove the file to recreate confluence.cfg.xml 
4 - configuring the connection to the empty database 
5 - Restoration from a daily backup 
6 - In progress to 30% and then error ...

Regards,

Marouen.

FelipeA · Answer

Hi Marouen,

It seems you trying to restore your Confluence in a database which already has data, is this the case?

If you're trying to restore a whole site backup, you'll have to do it on a newly created database.

Regards,

Felipe Alencastro