Migrate Ttrss From Host Mysql To Docker Postgresql
Posted on December 10, 2024
a long overdue migration has finally been done. here are some notes to remember
- for data export you need the opml file and the actual data dump
- opml export via web interface
- data dump via data_migration plugin
- as the user owning ttrss, in the subfolder > plugins.local do
git clone https://gitlab.tt-rss.org/tt-rss/plugins/ttrss-data-migration.git data_migration
- add this to the host config file to allow the plugin:
putenv('TTRSS_PLUGINS=auth_internal, data_migration');
- then run `./update.php –data_user YOUR_TTRSS_USER –data_export FILENAME.zip
- as the user owning ttrss, in the subfolder > plugins.local do
- set up new ttrss docker instance as you prefer
- first run with the
updater
container commented out - import opml on web ui
- import data dump in container
docker exec -it your_cointainer /bin/sh
- in /var/www/html/ttrss run as user
app
: `./update.php –data_user YOUR_TTRSS_USER –data_import FILENAME.zip
- ideally do this in a tmux session in case your connection dies
Hey! I'll happily receive your comments
via email.
Thanks for reading.

Andreas Wagner
freelance System Administrator and Ruby programmer in Tallinn, Estonia