Mattermost DB Migration Program

This program migrates Mattermost database from postgresql to mysql, or vice versa.

Pre-requirements

System Requirements

• JDK 7 (or higher) + Maven 3

• Can connect on both (postgresql/mysql) database system at the same time.

Conditions

• Using same version of Mattermost.

ex) v3.1 Mattermost running on postgresql database

to  v3.1 Mattermost running on mysql database

You can upgrade your Mattermost version after migration.

• Sobriety :-)

How-to-migrate

Clone this repository on machine's local path.

git clone [repository path]

Initialize target database.

• Setting mattermost/config/config.json to target database

• Running mattermost/bin/platform to create initial Mattermost schema.

Run mattermost (./bin/platform) and stop (Ctrl + C) when initialize complete.

• Truncate all tables.

In fact, just truncate Systems table will be enough. (At first, other table is empty)

Rename application.properties.default to application.properties

• Program will read application.properties

Setting program's application.properties

• Make sure that database's driver, url, username, password are correct.

Run program using maven exec.

 mvn compile exec:java -Dexec.mainClass="com.navercorp.mattermost.migration.Main"

This command will download libraries, compile classes, and run migration program.

Used Libraries

This program uses following libraries at it's build time.

Library Name	Version
Spring Framework	4.3.2
Spring Batch	3.0.7
Mysql JDBC Connector	5.1.31
Postgresql JDBC Connector	9.4.1208.jre7
Lombok	1.16.8
Snakeyaml	1.17

Limitation

This is not official migration program, it uses not recommended way to migration.

(In fact, there is no recommended way to migration at now.)

This program may make wrong result on target database, so you MUST check migrated data before you shutdown original database.

License

Apache License 2.0

Author

Sang Jun Lee <[email protected]>