Template:VALT Server Migration: Difference between revisions

From IVS Wiki
Jump to navigation Jump to search
Line 31: Line 31:
<li>Type in the following, then press {{Keyboard | key = Enter}}:</li>
<li>Type in the following, then press {{Keyboard | key = Enter}}:</li>
<code>mysqldump -uivsadmin -p valt > valt.sql</code>
<code>mysqldump -uivsadmin -p valt > valt.sql</code>
<li>Enter in the mysql password</li>
<li>Enter in the MySQL password and press {{Keyboard | key = Enter}}:</li>
</ol>
</ol>
</div><br>
</div><br>
Line 40: Line 40:
<li>Copy over the database file to the new server</li>
<li>Copy over the database file to the new server</li>
<code>scp valt.sql ivsadmin@'''NewServerIP''':/home/ivsadmin/</code>
<code>scp valt.sql ivsadmin@'''NewServerIP''':/home/ivsadmin/</code>
<li>Enter password for '''ivsadmin'''</li>
<li>Enter password for '''ivsadmin''' and press {{Keyboard | key = Enter}}:</li>
</ol>
</ol>
</div><br>
</div><br>

Revision as of 16:19, 3 August 2022

Note: Change IP's in the below commands to match the IP's of the new and old server


On the Old Server

  1. Disable the Apache web service to prevent further recordings:
    sudo service apache2 stop
  2. Disable the restart Wowza cronjob:
    - Type in the following command:
    crontab -e
    - Press 1 to continue




  1. Comment out the following job:
  2. 0 3 * * * /usr/local/valt/bin/restartwowza
  3. Press CTRL + X to exit
  4. Press Y to save




  1. Type in the following, then press Enter:
  2. sudo chmod 777 -R /usr/local/WowzaStreamingEngine/content/
  3. Type in the following, then press Enter:
  4. mysqldump -uivsadmin -p valt > valt.sql
  5. Enter in the MySQL password and press Enter:




  1. Copy over the database file to the new server
  2. scp valt.sql ivsadmin@NewServerIP:/home/ivsadmin/
  3. Enter password for ivsadmin and press Enter:


On the New Server

  1. Type in the following and press Enter:
    mysql -uivsadmin -p valt
  2. Enter in the MySQL password and press Enter:



  1. Type in the following and press Enter:
  2. DROP database valt;


:


  1. Type in the following and press Enter:
  2. CREATE database valt;


:


  1. Type in the following and press Enter:
  2. exit
  3. Type in the following and press Enter:
  4. mysql -uivsadmin -p valt < valt.sql
  5. Enter in the MySQL password and press Enter:



  1. Type in the following and press Enter:
  2. mysql -uivsadmin -p valt -e "UPDATE wowza SET address = 'NewServerIP'"
  3. Enter in the MySQL password and press Enter:


Copy the Recordings Folder to the New Server

Copy the Recordings Folder to a New Server