TTRSS Migration to New Server

  1. Prepare the old Server
  2. Stop the update service e.g. service ttrss stop
  3. Export the DB, assuming you're using Postgresql: sudo -u postgres pg_dump ttrss > dbdump
  4. Prepare new server1
    a. Install PHP: apt-get install php5 php5-fpm php5-curl php5-pgsql php5-gd php5-mcrypt php5-cli b. Install nginx mainline2

    c. Copy your old nginx config

    d. Install Postgresql apt-get install postgresql

    e. Login and create ttrss user and DB:

        sudo -u postgres psql postgres 
        \password postgres
        postgres=# CREATE USER ttrss WITH PASSWORD 'password';
        postgres=# CREATE DATABASE ttrssdb;
        postgres=# GRANT ALL PRIVILEGES ON DATABASE ttrssdb to ttrss;    

    f. Import old DB: sudo -u postgres psql ttrss < dbdump

    g. Grab the latest TT-RSS: git clone tt-rss

    h. Connect to TTRSS via your browser, follow the instructions, but don't initialize DB