Import backup failed

[Maciej Jaroński]

Hi!

I have the following problem - I'm trying to import xml backup to confluence.

It is quite large, about 5 GB

This import is a step in migrating the database from mySQL to postgresql

Unfortunately, restore throws an error every time:

 

I tried to restore in different variants, at times with the lowest server usage, with an increased pool size, the effect is still the same.

Does anyone have any suggestions on what could change this state of affairs?

Regards :)

[Shawn Doyle - ReleaseTEAM · Accepted solution]

Hi @Maciej Jaroński 

I have not had great luck with using the XML backup to migrate databases.  I prefer to use the database tools to migrate.

Here is Postgres' docs to migrate from other DBs to postgres.

https://wiki.postgresql.org/wiki/Converting_from_other_Databases_to_PostgreSQL

If you want to try troubleshooting the XML restore, here is Arlassian's doc. 

https://confluence.atlassian.com/doc/troubleshooting-failed-xml-site-backups-149212.html