User Tools

Site Tools


en:migrage-tms

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
en:migrage-tms [2022/03/14 11:56] – Денис Цыгановen:migrage-tms [2025/07/29 15:26] (current) – Константин Сегаль
Line 61: Line 61:
 <code> <code>
 psql -U tvip-tms tvip-tms  < /backup/tvip-tms.sql psql -U tvip-tms tvip-tms  < /backup/tvip-tms.sql
 +</code>
 +
 +:!: Restore dumps of additional databases if needed:
 +<code>
 +psql -U tvip-tms tvip-tms-vod  < /backup/tvip-tms-vod.sql
 +psql -U tvip-tms tvip-tms-audit  < /backup/tvip-tms-audit.sql
 </code> </code>
  
Line 66: Line 72:
 <code> <code>
 psql -U tvip-tms tvip-tms psql -U tvip-tms tvip-tms
-update device set authkey = '';+update device set authkey = null;
 \q \q
 </code> </code>
 +
 +=====  Creating and restoring a MongoDB backup =====
 +
 +Create a backup copy of the MongoDB database, using the utility **mongodump**
 +
 +<code>
 +mongodump --db images --gzip --archive > /mongoBackup/images.dump.gz 
 +</code>
 +
 +Install the MongoDB database on the new server:
 +
 +<code>
 +# apt install mongodb-org
 +# systemctl start mongod.service
 +# systemctl enable mongod.service
 +</code>
 +
 +Restore a MongoDB backup, using the utility **mongorestore**
 +
 +<code>
 +mongorestore --gzip --archive=/mongoBackup/images.dump.gz  
 +</code>
 +
 +:!: If you want to keep statistics, save and restore a backup for the database **content**
 +
 +<code>
 +mongodump --db content --gzip --archive > /mongoBackup/content.dump.gz 
 +mongorestore --gzip --archive=/mongoBackup/content.dump.gz
 +</code>
 +
 +
 ===== Deploy new TMS ===== ===== Deploy new TMS =====
  
en/migrage-tms.1647258963.txt.gz · Last modified: by Денис Цыганов

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki