Revision as of 10:08, 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:
```
mysql -uivsadmin -p valt
```
Type in the password to MySQL.
Type:
```
DROP database valt;
```
Type:
```
CREATE database valt;
```
Type in the following, then press Enter:
```
exit 
```
Type in the following, then press Enter:
```
mysql -uivsadmin -p valt < valt.sql
```
Enter the password for MySQL.

Type in the following, then press Enter:

mysql -uivsadmin -p valt -e "UPDATE wowza SET address = 'NewServerIP'"

@@ Line 15: / Line 15: @@
 # Type in the following, then press Enter: <pre>mysql -uivsadmin -p valt</pre>
 # Type in the password to MySQL.
-#:{{img | file = ValtMigrationMysqlLogin.jpg}}
+#:{{img | file = MySQL_Login.png}}
 # Type: <pre>DROP database valt;</pre>
-#:{{img | file = ValtMigrationDropDb.jpg}}
+#:{{img | file = Database_DROP.png}}
 # Type:<pre>CREATE database valt;</pre>
-#:{{img | file = ValtMigrationCreateDb.jpg}}
+#:{{img | file = Database_CREATE.png}}
 # Type in the following, then press Enter: <pre>exit </pre>
-# Type in the following, then press Enter '''(Since Ubuntu 18.04 ivsadmin is the MySQL login user)''': <pre>mysql -uivsadmin -p valt < valt.sql</pre>
+# Type in the following, then press Enter: <pre>mysql -uivsadmin -p valt < valt.sql</pre>
 # Enter the password for MySQL.
-#: {{img | file = ValtMigrationMysqlV3.jpg}}
+#: {{img | file = Database_IMPORT.png}}
-# Type in the following, then press Enter '''(Since Ubuntu 18.04 ivsadmin is the MySQL login user)''': <pre>mysql -uivsadmin -p valt -e "UPDATE wowza SET address = 'NewServerIP'"</pre>
+# Type in the following, then press Enter: <pre>mysql -uivsadmin -p valt -e "UPDATE wowza SET address = 'NewServerIP'"</pre>
 # Enter the password for MySQL.
-#: {{img | file = ValtMigrationSetWowzaIp.jpg}}
+#: {{img | file = MySQL_Wowza_Update_Address.png}}
 =Copy the recordings folder to the new server=
 {{:Copy the Recordings Folder to a New Server}}