whysthatso

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
  • 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