Template:VALT Server Migration: Difference between revisions
Jump to navigation
Jump to search
IVSWikiBlue (talk | contribs) |
IVSWikiBlue (talk | contribs) |
||
| Line 46: | Line 46: | ||
=On the New Server= | =On the New Server= | ||
# Type in the following | |||
# | <div class="section"> | ||
# Type in the following and press {{Keyboard | key = Enter}}: | |||
#: <code>mysql -uivsadmin -p valt</code> | |||
# Enter in the MySQL password and press {{Keyboard | key = Enter}}: | |||
</div><br> | |||
: {{img | file = MySQL_Login.png}} | |||
<br> | |||
<div class="section"> | |||
<ol start="3"> | |||
<li>Type in the following and press {{Keyboard | key = Enter}}:</li> | |||
<code>DROP database valt;</code><br> | |||
</ol> | |||
</div><br> | |||
: :{{img | file = Database_DROP.png}} | |||
<br> | |||
<div class="section"> | |||
<ol start="4"> | |||
<li>Type in the following and press {{Keyboard | key = Enter}}:</li> | |||
<code>CREATE database valt;</code><br> | |||
</ol> | |||
</div><br> | |||
: :{{img | file = Database_CREATE.png}} | |||
<br> | |||
<div class="section"> | |||
<ol start="5"> | |||
<li>Type in the following and press {{Keyboard | key = Enter}}:</li> | |||
<code>exit</code><br> | |||
<li>Type in the following and press {{Keyboard | key = Enter}}:</li> | |||
<code>mysql -uivsadmin -p valt < valt.sql</code><br> | |||
<li>Enter in the MySQL password and press {{Keyboard | key = Enter}}:</li> | |||
</ol> | |||
</div><br> | |||
: {{img | file = Database_IMPORT.png}} | |||
<br> | |||
<div class="section"> | |||
<ol start="8"> | |||
<li>Type in the following and press {{Keyboard | key = Enter}}:</li> | |||
<code>mysql -uivsadmin -p valt -e "UPDATE wowza SET address = '<b>NewServerIP</b>'"</code><br> | |||
<li>Enter in the MySQL password and press {{Keyboard | key = Enter}}:</li> | |||
</ol> | |||
</div><br> | |||
: {{img | file = MySQL_Wowza_Update_Address.png}} | |||
=Copy the Recordings Folder to the New Server= | =Copy the Recordings Folder to the New Server= | ||
{{:Copy the Recordings Folder to a New Server}} | {{:Copy the Recordings Folder to a New Server}} | ||
Revision as of 13:55, 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
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
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:
exitmysql -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'"








