Revision as of 07:55, 2 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

It is beneficial to stop the apache service on the old server to prevent further recording of videos on it

Type in the following, then press Enter:

sudo chmod 777 -R /usr/local/WowzaStreamingEngine/content/

Type in the following, then press Enter:
```
mysqldump -uivsadmin -p valt > valt.sql
```
Enter mysql password

Type in the following, then press Enter:

scp valt.sql ivsadmin@NewServerIP:/home/ivsadmin/

Type in the following, then press Enter (Since Ubuntu 18.04 ivsadmin is the MySQL login user):
```
mysql -uroot -p v3
```
Type in the password to MySQL.
Type:
```
DROP database v3;
```
Type:
```
CREATE database v3;
```
Type in the following, then press Enter:
```
exit 
```
Type in the following, then press Enter (Since Ubuntu 18.04 ivsadmin is the MySQL login user):
```
mysql -uroot -p v3 < v3.sql
```
Enter the password for MySQL.
Type in the following, then press Enter (Since Ubuntu 18.04 ivsadmin is the MySQL login user):
```
mysql -uroot -p v3 -e "UPDATE wowza SET address = 'NewServerIP'"
```
Enter the password for MySQL.

@@ Line 7: / Line 7: @@
 # Type in the following, then press Enter: <pre>mysqldump -uivsadmin -p valt > valt.sql</pre>
 #Enter mysql password
-#:{{img | file = ValtMigrationMysqlDump.jpg}}
+#:{{img | file = VALT_Migration_MySQLdump.png}}
 # Type in the following, then press Enter: <pre>scp valt.sql ivsadmin@NewServerIP:/home/ivsadmin/</pre>
 # Enter password for ivsadmin.
-#:{{img | file = ValtMigrationScpCommand.jpg}}
+#:{{img | file = SCP_MySQLdump.png}}
 =On the New Server=