Urchin 5 to Urchin 6 Upgrade How To 5

Posted by Ben Reubenstein Wed, 09 Sep 2009 14:04:00 GMT

Over the past several weeks I have been struggling with getting Urchin 5 upgraded to Urchin 6. Much has been learned, here are the steps:

  1. Install Urchin 6. The wizard for this is fairly straightforward. Prior to starting the installer be sure to have mysql installed, a database created for urchin, and a mysql user that has full permissions on the Urchin database.

  2. If Urchin 6 resides on a new server, copy the entire urchin 5 directory to the new server. I tried to get fancy with NFS mounts, and it was a world of hurt when trying to import. Copying the data will ensure no issues. The fastest way is to use rsync, here is an example command to do it over SSH:

    $ rsync -vaz --rsh="ssh -l USER" /PATH/TO/urchin5/ \ URCHINSERVERHOSTNAME:/PATH/TO/urchin5_files

  3. Export the urchin 5 setup data on the urchin 5 box. This includes profiles, users, etc... Note you must always run commands from the directory in which they reside.

    $ cd /YOUR/URCHIN5/INSTALL/util
    $ sudo ./uconf-export > /home/YOURUSER/urchin5.data

  4. If Urchin 6 is on another server, copy the urchin5.data file to the new server. Import the data.

    $ cd /YOUR/URCHIN6/INSTALL/util
    $ sudo uconf2sql -f /PATH/TO/urchin5.data

  5. Finally import the actual analytics data for all profiles. It is crucial that you use the -z option if your copy of Urchin 5 had archiving turned on. If you don't, the import will only grab recent data. If you have a lot of data the task can take a while, consider running the command in a screen so you can log out of the box and it will continue running.

    $ cd /YOUR/URCHIN6/INSTALL/util
    $ sudo ./convert-u5data -d -z -c /PATH/TO/urchin5/

Reference:
Urchin 5 to 6 documentation from Urchin.