Brad Fitzpatrick (bradfitz) wrote in lj_dev,
Brad Fitzpatrick
bradfitz
lj_dev

DB Updater

I'm writing a tool right now that'll examine your LJ installation's database and bring it up to date... adding new tables, altering existing tables, etc.

For now it'll do a lot of checks like "does this table/column/index exist?" but in the future it'll also register the SQL change number (scn) that it's at in the database, in a new table called "siteinstall" or something. Then in the future it can just run anything with an SCN greater than what it's already done.

In the future, updating your LJ installation & database will be as easy as:

$ cd $LJHOME
$ cd cvs/livejournal
$ cvs update
$ ~/bin/cvsreport --sync
$ cd $LJHOME
$ bin/upgrading/update-db.pl
$ su
# apachectl graceful


It's not that easy yet, but hopefully soon.
Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 3 comments