Blogs

Restoring Kaltura CE5

June 19, 2012 by Arvind Das

I have a new installation of Kaltura CE5 on my machine and i want to fetch data from previous installation in my current Kaltura CE5. This is how, I have achieve this.

  • Export your CE 5 Data Base
  • Run the following command (replace [user] and [password] with relevant values:

    mysqldump kaltura -u[user] -p[password] > kaltura.sql
    
  • Install CE 5.0
  • Backup CE5 installation data, /opt/kaltura/web directory and install Kaltura CE5.

  • Rsync back up web directory to your CE5 web directory
  • For example

    rsync -r pathtobackup/web/ /opt/kaltura/web/
    
  • Replace values for (only) batch partner “-1” from new database with values in backup kaltura.sql file. Replace old values with new one in kaltura.sql
  • Import your CE5 DataBase from previous installation
  • Run the following command (replace [user] and [password] with relevant values):

    mysql kaltura -u[user] -p[password] < kaltura.sql
    
  • Run the migration scripts
  • php /opt/kaltura/app/deployment/updates/update.php 
    
  • If still videos do not display under content tab execute this script
  • php /opt/kaltura/app/scripts/utils/updatePartnerEntries2Sphinx.php “partner_id”
    
  • It should execute without errors else execute again.
  • If videos do not play
  • chmod -R 777 /opt/kaltura/web/content/entry/data
    
  • Execute the script below if you are unable to see newly uploaded content after rebooting server
  • /usr/bin/php /opt/kaltura/app/plugins/sphinx_search/scripts/populateFromLog.php /opt/kaltura/app/plugins/sphinx_search/scripts/configs/server-sphinx.php
    
  • Run the Above script as a background process. Follow Instructions below
  • create a file as sphinx_server.sh and copy the above code into it as
  • #!/bin/sh
    /usr/bin/php /opt/kaltura/app/plugins/sphinx_search/scripts/populateFromLog.php /opt/kaltura/app/plugins/sphinx_search/scripts/configs/server-sphinx.php > /dev/null 2>&1 & 
    
  • save and change its permissions to chmod +x sphinx_server.sh
  • Add the line below in /etc/rc.local so that it starts executing after server is rebooted
  • Comments

    • Posted : by Hung Phan

      Thanks for detailed instructions. I have few questions though: 1. Do I need to stop any services (https, sphinx_watch.sh,etc.) at any point? 2. If I use a new virtual host name in the new installation, what other changes are needed? No video content

    Leave a comment

    Your email address will not be published. Required fields are marked *

    You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

    Follow Us

    Recent Entries