TinyTinyRss Data Migration - Baota Environment

Feb 5, 2020#TinyTinyrss #免费 #开源 #rss42

AI Translation

This post is translated from Chinese into English through AI.View Original

AI-generated summary

The process involves backing up the website's root directory, exporting the database, creating a new website, importing old data and the database, modifying database information in config.php, ensuring the new site uses HTTPS, enabling phpfileinfo, and setting up automatic updates via crontab. Additionally, it includes a SQL command to replace specific content in the feed_url field of the ttrss_feeds table.

Process Record#

Overall Backup of Website Root Directory#

Database Data Export#

Create New Website#

Import Old Data and Database#

Old Website is https, New Site Also Needs to Be Enabled#

Enable phpfileinfo#

Enable Automatic Updates#

`crontab -u www -e`#

Add Content#

*/30 * * * * www-data /usr/bin/php /var/www/ttrss/update.php --feeds --quiet

Modify the path and permissions yourself (non-root permissions)

Reload#

  ` service crond reload`
   Restart
   `service crond restart` 
   Check Status
  ` tail -f /var/log/cron `

SQL Data Replacement#

Replace content A with B in the field feed_url of the table ttrss_feeds

UPDATE ttrss_feeds SET feed_url = replace(feed_url, 'A', 'B')