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.
November 18th, 2006 at 3:03 am 1
Wow! Rather coincidental, but that’s exactly what I needed just now. I could have taken the time to figure that out (I have next to no database experience) but it’s nice to have clear-cut instructions laid out for me