Difference between revisions of "Stacks"
| Line 3: | Line 3: | ||
=Steps= | =Steps= | ||
| − | * create database, you must have the appropriate privileges for this. If you do the command will be something like: | + | * create database, you must have the appropriate privileges for this. If you do, the command will be something like: |
| − | echo "create database < | + | echo "create database <mynewdbname>" | mysql -h <name_of_server_running_mysql> -u <myusername> -p |
| − | |||
* 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, i.e. | * 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 | mysql <mydbname> -h <name_of_server_running_mysql> -u <myusername> -p < $STACKSROOTDIR/share/stacks/sql/stacks.sql | ||
Revision as of 13:04, 19 April 2016
Dominant Radseq analysis software protocol by Julian Catchen.
Steps
- create database, you must have the appropriate privileges for this. If you do, the command will be something like:
echo "create database <mynewdbname>" | mysql -h <name_of_server_running_mysql> -u <myusername> -p
- 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
