BioSQL/Windows
(Difference between revisions)
m (v5.1) |
(→MySQL) |
||
| Line 1: | Line 1: | ||
| + | These are Windows specific notes on installing [[BioSQL]] | ||
| + | |||
=== MySQL === | === MySQL === | ||
| − | + | Download and install MySQL 5.1 from http://dev.mysql.com/downloads/mysql/5.1.html#win32 | |
| + | |||
| + | Download and install MySQLdb (the python interface) from http://sourceforge.net/projects/mysql-python | ||
| + | |||
| + | Get the schema from http://cvs.open-bio.org/cgi-bin/viewcvs/viewcvs.cgi/biosql-schema/sql/biosqldb-mysql.sql?cvsroot=biosql | ||
| + | |||
| + | Create a new database, and load the schema etc as described on [[BioSQL]] | ||
| − | + | mysqladmin -u root create bioseqdb | |
| + | mysql -p -u root bioseqdb < biosqldb-mysql.sql | ||
Revision as of 20:52, 14 December 2007
These are Windows specific notes on installing BioSQL
MySQL
Download and install MySQL 5.1 from http://dev.mysql.com/downloads/mysql/5.1.html#win32
Download and install MySQLdb (the python interface) from http://sourceforge.net/projects/mysql-python
Get the schema from http://cvs.open-bio.org/cgi-bin/viewcvs/viewcvs.cgi/biosql-schema/sql/biosqldb-mysql.sql?cvsroot=biosql
Create a new database, and load the schema etc as described on BioSQL
mysqladmin -u root create bioseqdb mysql -p -u root bioseqdb < biosqldb-mysql.sql
