Error when importing Jira Backup Edited

[Craig Thacker]

Currently, I am trying to restore a backup of our old Jira 7.12.3 by moving it to  local VM, when I import the .zip/XML file, I get this error:

Error importing data: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM component (Table 'jiradb.component' doesn't exist))

 The original Jira application was hosted on an Ubuntu 18.04 VM and I am trying to move this to a CentOS 7 VM, both running MySQL.

I have exported the XML from our archived machine just the other day using a system administrator account, and I am unfamiliar with the original setup of our Jira server as it was my predecessor who completed it.

I originally tried importing with the most recent version of Jira and assumed the error (same as above) was because of a mis-matching version, so decided I'd install again using the same version.

Any tips on how I can restore the backup?

UPDATE:

I have also attempted the import on a Windows Server machine (also running MySQL) and got the same error:

Error importing data: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM component (Table 'jiradb.component' doesn't exist))

So I find it likely its a problem with my export but I'm unsure

[juliangcorrea]

Same here. Waiting for solution.

[juliangcorrea]

Im my case, I was using mysql 8. 
I have changed to mysql 5.7 and issue were gone.