Confluence Documentation

Confluence 4.1.x
Confluence 4.0.x
Confluence 3.5.x
Confluence 3.4.x
More...

Search the Knowledge Base and Documentation Spaces

Browse Content

You're visiting the Confluence Knowledge Base. Visit the Confluence Knowledge Base Home for an overview.

Skip to end of metadata
Comment: Migration of unmigrated content due to installation of a new plugin
Go to start of metadata

Atlassian recommends disabling the XML backup both for performance and reliability. Setting up a test server and the Production Backup Strategy is better done with an SQL dump. Upgrading Confluence is better done without the XML backup.

The one operation for which an XML backup is required is database migration. For this we recommend a commercial database migration tool. Vote for CONF-12599 to add a more robust strategy for large implementation migrations. Atlassian does not support migrating to a new database.

Symptoms

When importing a backup or space export, the import fails with this message in your logs:

Cause

A MySQL 3.0 jdbc driver (or other drivers pre 3.1 jdbc drivers) are not compatible with MySQL 4.x, 5.x and confluence (Please refer to Database Setup for MySQL).

Resolution

Upgrade to the latest jdbc driver for MySQL which you can download from here.

Related Content

 Expand to see related content
Related Content with Label 'restore_backup'
Page: Cannot Restore XML Backup Due to 'null value in column destpagetitle violates not-null constraint'
Page: Cannot Restore XML Backup Due to Data Truncation - MySQL Driver 3.1
Page: Cannot Restore XML Backup due to Value too Large for Column
Page: Cannot Restore XML Backup due to Database Encoding
Page: Cannot Restore XML Backup Due to Invalid Page Title when Using MS SQL
Page: Unique Constraint Violation Due to Value too Large for Column
Page: Cannot Restore XML Backup Due to Database Permissions
Page: Cannot Restore XML Backup due to Null Attachment
Page: Cannot Restore XML Backup Due to Data Truncation - Limits on Columns
Page: XML Import Failed with 'Too many open files' Error
Showing first 10 of 12 results
Related Content with Label 'installation'
Page: Cannot Restore XML Backup Due to Data Truncation - MySQL Driver 3.1
Page: Exports to PDF Broken Due to X11 Library
Page: Unable to Complete Installation Due to File Permissions
Page: Confluence and SOAP on Resin
Page: Installation or Upgrade of Confluence 4.0 EAR-WAR Fails on Red Hat or CentOS
Page: Unable to Install Due to Kaffe Java
Page: Installation Fails with 'java.lang.ClassNotFoundException org.apache.juli.ClassLoaderLogManager' Due to JDK Version
Page: Setup Wizard Fails to Create Admin User
Page: 'extractBundledPlugins Couldn't find atlassian-bundled-plugins.zip on classpath' Due to Solaris TAR Utility
Page: 'index 'sp_comp_idx' exceeds the maximum length of 900 bytes' Using SQL Server
Showing first 10 of 22 results
Related Content with Label 'mysql'
Page: Getting 'can't create or write to file' SQLException Error When Browsing a Space
Page: Cannot Restore XML Backup Due to Data Truncation - MySQL Driver 3.1
Page: Unable to Install Calendar plugin
Page: 'java.sql.BatchUpdateException Lock wait timeout exceeded' Errors Due To nested transactions with MySQL
Page: Getting 'Communications link failure' CommunicationsException Error with JIRA User Management on MySQL
Page: Getting 'Communications link failure' CommunicationsException Error when Making XML Backup
Page: Confluence will not start using MySQL 5.1.5+ with Binary Logging
Page: Database Errors when Using MySQL and MyISAM Tables
Page: Setup Fails Creating MySQL Schema Due to Tomcat Incompatibility
Page: Cannot Create XML Backup Due to Corrupt Table
Showing first 10 of 26 results
Help us improve!
Is this article helpful?
Is the content complete?
Is it well written?