Difference between revisions of "Template:VALT Server Migration"
IVSWikiBlue (talk | contribs) (→On the Old Server) |
IVSWikiBlue (talk | contribs) |
||
| Line 79: | Line 79: | ||
</ol> | </ol> | ||
</div><br> | </div><br> | ||
| − | : {{img | file = Database_IMPORT.png}} | + | : {{img | file = Database_IMPORT.png}}<br> |
<br> | <br> | ||
<div class="section"> | <div class="section"> | ||
| Line 89: | Line 89: | ||
</div><br> | </div><br> | ||
: {{img | file = MySQL_Wowza_Update_Address.png}} | : {{img | file = MySQL_Wowza_Update_Address.png}} | ||
| − | + | <br> | |
| − | |||
{{:Copy the Recordings Folder to a New Server}} | {{:Copy the Recordings Folder to a New Server}} | ||
Revision as of 10:46, 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
- Disable the Apache web service to prevent further recordings:
-
sudo service apache2 stop
-
- Disable the restart Wowza cronjob:
- - Type in the following command:
-
crontab -e - - Press 1 to continue
- Comment out the following job:
- Press CTRL + X to exit
- Press Y to save
0 3 * * * /usr/local/valt/bin/restartwowza
- Type in the following, then press Enter:
- Type in the following, then press Enter:
- Enter in the MySQL password and press Enter:
sudo chmod 777 -R /usr/local/WowzaStreamingEngine/content/
mysqldump -uivsadmin -p valt > valt.sql
- Copy over the database file to the new server
- Enter password for ivsadmin and press Enter:
scp valt.sql ivsadmin@NewServerIP:/home/ivsadmin/
On the New Server
- Type in the following and press Enter:
-
mysql -uivsadmin -p valt
-
- Enter in the MySQL password and press Enter:
- Type in the following and press Enter:
DROP database valt;
- :
- Type in the following and press Enter:
CREATE database valt;
- :
- Type in the following and press Enter:
- Type in the following and press Enter:
- Enter in the MySQL password and press Enter:
exit
mysql -uivsadmin -p valt < valt.sql
- Type in the following and press Enter:
- Enter in the MySQL password and press Enter:
mysql -uivsadmin -p valt -e "UPDATE wowza SET address = 'NewServerIP'"
