Migrating Confluence got error : Table confluence.BANDANA doesn't exist'

[tiendungitd]

Hi everyone

after I migrated confluence from windows server to new ubuntu server, I got error. I restored db from old server to new one. I also try to fix by the link https://confluence.atlassian.com/confkb/upgrade-fails-java-sql-sqlexception-table-confluence-bandana-doesn-t-exist-due-to-case-sensitivity-123044020.html but no luck.

In windows server: Confluence version 5.10.2

In Ubuntu Server: Confluence version 5.10.8

image2016-10-31 15:34:56.png

Please advise me how to fix this issue.

Thanks.

[Warren Ludcke]

I know this is a bit old now, but if you move your MySQL database from Windows to Linux, consider setting lower_case_table_names=1 in your Linux MySQL configuration, otherwise when you restore your Windows MySQL backup into Linux MySQL Confluence may give you this error because of table name case sensitivity issues.

See https://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html for details.

[tiendungitd]

Hi @Jonas Andersson

as you advise, I installed another Confluence server with same version to import, then I got another problem. I also tried some solutions to fix it like the link https://confluence.atlassian.com/confkb/confluence-generates-confluence-is-vacant-error-on-install-779164449.html and fix incorrect database collation, but no luck, the problem still be there.

image.png

[tiendungitd]

Thanks @Jonas Andersson, I will try with confluence 5.10.2 on linux. Due to we have a large data, so can not import by XML, I just import DB, copy home directory from win server to linux server. 

[Jonas Andersson]

This is probably because you need to import it on the same version of confluence as you used. Install confluence 5.10.2 on linux, import the XML, then upgrade it should work fine.