Difference between revisions of "Stacks"

From wiki
Jump to: navigation, search
Line 7: Line 7:
 
* 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, i.e.
 
* 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
+
  mysql <mydbname> -h <name_of_server_running_mysql> -u <myusername> -p < $STACKSROOTDIR/share/stacks/sql/stacks.sql

Revision as of 12:53, 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> -h <name_of_server_running_mysql> -u <myusername> -p < $STACKSROOTDIR/share/stacks/sql/stacks.sql