Upgrading/Data Version 9

These instructions are for upgrading your database to data version 9. This update is for performance improvements so that icons can be renamed.

The first step is to upgrade to the lastest code as described in Updating the Dreamwidth code, especially:

cd $LJHOME
bin/cvsreport.pl -update
# only sync changes from the CVS to the live code
bin/cvsreport.pl -sync -cvsonly
bin/cvsreport.pl -sync -cvsonly

# order of commands is important
$LJHOME/bin/upgrading/update-db.pl -r -p --innodb
$LJHOME/bin/upgrading/update-db.pl -r --cluster=all --innodb
$LJHOME/bin/upgrading/texttool.pl load

It's also recommended that you delete files that don't exist in the code anymore from $LJHOME:

cd $LJHOME
for i in $(bin/cvsreport.pl -n -1); do 
   echo "Removing $i" && rm $i; 
done

Then, you will want to run this program:

perl $LJHOME/bin/upgrading/d8d9-userpicrename.pl

Here's an example of the help output and usage output of the script:

dw@dw-dev:~$ ~/bin/upgrading/d8d9-userpicrename.pl --help
Usage: /home/dw/bin/upgrading/d8d9-userpicrename.pl [options]
Options:
    --cluster=N Specify user cluster to work on (by default, all clusters)
    --hours=N   Work no more than N hours (by default, work until all is done)
    --user=N    Specify users to migrate (by default, all users on the specified clusters)
    --verbose   Be noisy
    --help      Print this help and exit
dw@dw-dev:~$ ~/bin/upgrading/d8d9-userpicrename.pl
Do you want to update to dversion 9 (userpicmap3)? [N/y] y

--- Upgrading users to dversion (userpicmap3) ---

	Total users at dversion 8: 0

	Got 0 users on cluster 0 with dversion=8
	Got 0 users on cluster 1 with dversion=8
	Got 0 users on cluster 2 with dversion=8
--- Done migrating 0 of 0 users to dversion 9 ---
dw@dw-dev:~$