Skip to content

Upgrade manual

In general, to upgrade to a new version, you need to

  1. Pull a new docker image version
  2. Stop the service and do the database migration manually
  3. Restart the service

If there are extra notes for a specific version, you can find it here: extra notices

Get latest SeaTable

You can find all versions of SeaTable from Docker Hub.

Run the following command to get the latest version of Seatable.

docker pull seatable/seatable-developer:{tag}

Stop the currently running SeaTable container.

docker compose down

Then modify SeaTable version in "docker-compose.yml". And start a new SeaTable container.

docker compose up -d

Upgrade database

Major or minor version upgrade

Major version upgrade, like from 1.x to 2.x, and minor version upgrade, like from 1.1.x to 1.2.x, involve database changes. You need to manually change the database like following:

docker exec -it seatable /bin/bash # Login to the SeaTable container. Then execute the upgrade statement upgrade-sql 1.1 upgrade-sql 1.2

If the above commands failed to execute for some reasons, (for example, you are using external database instead of the default one started by docker-compose), you can execute the database upgrade commands manually as below:

docker exec -it seatable /bin/bash

mysql -h$DB_HOST -p$DB_ROOT_PASSWD dtable_db </opt/seatable/seatable-server-latest/sql/mysql/upgrade/1.1/dtable.sql
mysql -h$DB_HOST -p$DB_ROOT_PASSWD dtable_db </opt/seatable/seatable-server-latest/sql/mysql/upgrade/1.2/dtable.sql

If you upgrade several versions at once, just run all the database upgrade statement one by one, starting from the lowest version.

Tiny version upgrade

Tiny version upgrade, like from 1.0.1 to 1.0.2, does not involve database changes.

Start SeaTable server

Now you can start the SeaTable service. Execute the following command in the host server:

docker exec -d seatable /shared/seatable/scripts/ start

Last update: October 20, 2023