Difference between revisions of "Stacks"
(Created page with "Dominant Radseq analysis software protocol by Julian Catchen. =Steps= * create database * ensure $STACKSROOTDIR/share/stacks/sql/my.cnf is set up properly * ensure modificat...") |
|||
| Line 6: | Line 6: | ||
* ensure $STACKSROOTDIR/share/stacks/sql/my.cnf is set up properly | * ensure $STACKSROOTDIR/share/stacks/sql/my.cnf is set up properly | ||
* ensure modification privileges for the user | * ensure modification privileges for the user | ||
| − | * load '''stack.sql''' schema onto the database. It's in $STACKSROOTDIR/share/stacks/sql/stacks.sql | + | * load '''stack.sql''' schema onto the database. It's in $STACKSROOTDIR/share/stacks/sql/stacks.sql, i.e. |
| + | mysql <mydbname> -u <myusername> -p < $STACKSROOTDIR/share/stacks/sql/stacks.sql | ||
Revision as of 12:52, 19 April 2016
Dominant Radseq analysis software protocol by Julian Catchen.
Steps
- create database
- ensure $STACKSROOTDIR/share/stacks/sql/my.cnf is set up properly
- ensure modification privileges for the user
- load stack.sql schema onto the database. It's in $STACKSROOTDIR/share/stacks/sql/stacks.sql, i.e.
mysql <mydbname> -u <myusername> -p < $STACKSROOTDIR/share/stacks/sql/stacks.sql
