Revision as of 10:47, 4 December 2020

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 (Since Ubuntu 18.04 ivsadmin is the MySQL login user):
```
mysqldump -uroot -p v3 > v3.sql
```
Enter mysql password

Type in the following, then press Enter:

scp v3.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 = '192.168.1.73'"
```
Enter the password for MySQL.

Type in the following, then press Enter:

sudo scp -r ivsadmin@OldServerIP:/usr/local/WowzaStreamingEngine/content/valt_recordings/ /usr/local/WowzaStreamingEngine/content/

Type in the ivsadmin password.
After running the command above, you will want to select Yes to continue connecting to the server.
Let the files transfer to the new server. When they are complete, the window should look like the following example:

Note: Depending on the size of the system it can take quite some time for all the files to transfer.

@@ Line 13: / Line 13: @@
 =On the New Server=
-# Type in the following, then press Enter (Since Ubuntu 18.04 ivsadmin is the MySQL login user): <pre>mysql -uroot -p v3</pre>
+# Type in the following, then press Enter '''(Since Ubuntu 18.04 ivsadmin is the MySQL login user)''': <pre>mysql -uroot -p v3</pre>
 # Type in the password to MySQL.
 #:[[File:ValtMigrationMysqlLogin.jpg]]
@@ Line 21: / Line 21: @@
 #:[[File:ValtMigrationCreateDb.jpg]]
 # Type in the following, then press Enter: <pre>exit </pre>
-# Type in the following, then press Enter: <pre>mysql -uroot -p v3 < v3.sql</pre>
+# Type in the following, then press Enter '''(Since Ubuntu 18.04 ivsadmin is the MySQL login user)''': <pre>mysql -uroot -p v3 < v3.sql</pre>
 # Enter the password for MySQL.
 #: [[File:ValtMigrationMysqlV3.jpg]]
-# Type in the following, then press Enter: <pre>mysql -uroot -p v3 -e "UPDATE wowza SET address = '192.168.1.73'"</pre>
+# Type in the following, then press Enter '''(Since Ubuntu 18.04 ivsadmin is the MySQL login user)''': <pre>mysql -uroot -p v3 -e "UPDATE wowza SET address = '192.168.1.73'"</pre>
 # Enter the password for MySQL.
 #: [[File:ValtMigrationSetWowzaIp.jpg]]