Archive for November, 2006

  • Gene Ontology MySQL Quickstart

    Quickest way to set up a local GO DB with MySQL:

    Grab latest go-YYYYMM-seqdblite-tables.gz from here.
    tar -zxvf go-YYYYMM-seqdblite-tables.gz
    cd go-YYYYMM-seqdblite-tables
    echo “create database mygo” | mysql -uroot -p
    cat *.sql | mysql -uroot -p mygo
    mysqlimport -L -uroot -p mygo *.txt
    This is listed right on that same download page, but somehow I always forget that.

    Friday, November 17th, 2006
  • Backup gone awry

    By using rsync (an unfamiliar tool) with the –delete option, and not double-checking the backup, I was able to reformat my laptop and lose all my data.
    Lucky me.
    My most recent other backup is sitting on Monaco (about 3 months old), but my labmates keep stealing its ethernet cable. I’ll hopefully get it tomorrow, but my [...]

    Monday, November 13th, 2006