What Is Hgsql? How To Install And Work With It?
I got the following error
make -f infileMakefile testSet=YES MODEL=/data/ra1/Sim/model.txt
**hgsql** -Ne 'select name,chrom,strand,txStart,txEnd,cdsStart,cdsEnd,exonCount,exonStarts,exonEnds,score,name2,cdsStartStat,cdsEndStat,exonFrames from mgcGenes' hg19 > raw/mgcGenes.gp.tmp
/bin/bash: hgsql: command not found
make: *** [raw/mgcGenes.gp] Error 127
Note: I have mysql in my computer.
• 4,907 views
•
link
1 answer
This. It's part of the UCSC source tree under /kent/src/hg/hgsql, try to make the src tree from http://hgdownload.cse.ucsc.edu/admin/jksrc.zip
The code below does mostly the same as the follwing shell script:
#!/bin/sh
mysql -uuser -ppass $@
where it reads user and pass from some config file.
(A C program to execute mysql, WTH? xD)
/* hgsql - Execute some sql code using passwords in .hg.conf. */
#include "common.h"
#include "options.h"
#include "hgConfig.h"
#include "sqlProg.h"
void usage()
/* Explain usage and exit. */
{
errAbort(
"hgsql - Execute some sql code using passwords in .hg.conf\n"
"usage:\n"
" hgsql [mysqlOptions] [database]\n"
"or:\n"
" hgsql [mysqlOptions] [database] < file.sql\n"
"Generally anything in command line is passed to mysql\n"
"after an implicit '-A -u user -ppassword'. If no options\n"
"or database is specified, this usage message is printed."
"\n"
);
}
void hgsql(int argc, char *argv[])
/* hgsql - Execute some sql code using passwords in .hg.conf. */
{
static char *progArgs[] = {"-A", NULL};
sqlExecProg("mysql", progArgs, argc, argv);
}
int main(int argc, char *argv[])
/* Process command line. */
{
if (argc < 1)
usage();
hgsql(argc-1, argv+1);
return 0; /* never reaches here */
}
• 152 views
•
link
Log in to answer this question.
This might help http://skip.ucsc.edu/FAQ/FAQlicense.html
We have no idea from the question what make is targeting, i.e. what software is being installed.
I think that is some broken mysql wrapper from USCS or so.