Forum Discussion

Gowtham1's avatar
Gowtham1
Visitor
4 months ago

How to migrate Code Collaborator database from MySQL 5.6 on RedHat to MySQL 8.0 on Ubuntu?

Hi everyone,

I’m planning to migrate my Code Collaborator server from a RedHat environment running MySQL 5.6 to a new Ubuntu server running MySQL 8.0.

  • I have reviewed the official backup and migration documentation, but I want to confirm best practices for this migration.
  • Is the official Collaborator migration dump file compatible across these MySQL versions?

1 Reply

  • joseph_michaud's avatar
    joseph_michaud
    Icon for Staff rankStaff
    4 months ago

    When doing a migration consider that you are

    1. installing the Collaborator application
    2. moving the database
    3. moving content cache

    The easiest way to do this is to export a migration dump file on your source machine, install Collaborator on your destination machine, create a new empty database, and then import the migration dump file into the new empty database.  To do that you must use the same version of Collaborator on both source and destination machines.

    When exporting the migration dump file, you will specify to perform a complete system dump.  This copies the database into the zip file.  You will also specify to include file contents.  This copies the content cache into the zip file.  (For those who haven't read it) see this article:

    https://support.smartbear.com/collaborator/docs/server/admin-tasks/backup.html#migrate

    There shouldn't be any problems going from MySQL v5 to MySQL v8 but see the article about setting up for MySQL:

    https://support.smartbear.com/collaborator/docs/server/install/db/mysql.html

     

    The dump file is DB-agnostic.  It merely represents the tables in an XML format.