Regarding of restore

[Hyunmin Kim]

Hello.

I'm moving Cloud to Self-Hosted Jira.

When I try to restore the Jira system using export file(jira-export.zip), 

I got the error in below.

Please check this problem.

Thanks in advance!

[Nic Brough -Adaptavist- · Accepted solution]

The database you have chosen for your server installation does not support some of the characters you have in your data.

My guess is that you are using MySQL, MS-SQL or H2 (the internal one which you should not use for anything other than small dev or test systems) which all can have this problem.

Your options are:

• Remove the data that the database can't handle
• Use a database that can handle it (PostGres)
• Reconfigure the database so it can handle it.  Some people have reported that swapping the MySQL collation to utf8mb4 can fix it for example

See https://confluence.atlassian.com/jirakb/jira-does-not-work-with-emoji-4-byte-characters-429919955.html for a bit more.

[Hyunmin Kim]

@Nic Brough -Adaptavist- Thank you!
I tried to restore with PostGres. It works well.But I do not have more experience for PostGres. 

so I want to use the mysql for Jira.

 How can I remove the only data that can't handle in export zip file?

1. extract the "jira-export.zip"

2. remove words in xml

3. zipping

4. go restore

[Nic Brough -Adaptavist-]

Cleaning the xmlcan be done by searching for the stuff that cannot be handled by your database and manually removing it.

However, try the xml-cleaner first - see https://confluence.atlassian.com/jira/removing-invalid-characters-from-xml-backups-12079.html

[Hyunmin Kim]

Thank you!

Just I learn the PostGres. I can restore for backup data.

Please, close this issue.