Difference between revisions of "Template:VALT Server Migration"

From IVS Wiki
Jump to: navigation, search
(On the New Server)
(On the Old Server)
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 10: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

Edit Cronjobs Command.png


  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

Disable Restart Wowza Cronjob.png


  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:

VALT Migration MySQLdump.png


  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:

SCP MySQLdump.png

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:

MySQL Login.png


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


 :Database DROP.png


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


 :Database CREATE.png


  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:

Database IMPORT.png


  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:

MySQL Wowza Update Address.png

Copy the Recordings Folder to the New Server

Copy the Recordings Folder to a New Server