'ERROR 1045 (28000): Access denied' when trying to LOAD DATA INFILE.

2005-05-28 Thread Jeroen Van Goey
Hi all, I connect via ssh from a Linux RedHat 9 box to a remote FreeBSD server. There I can run MySQL and successfully add/remove tables etc. However, when I tried to upload a comma separated value file, I got an access denied error, although all privileges are granted to my account. What should

removing duplicates and giving average of other field.

2004-08-11 Thread Jeroen Van Goey
Hi again, thanks for the quick reply on my previous question, the solution given by Michael Stassen worked like a charm. But now I've again run into a situation where I'm stuck with my limited knowledge of MySQL. Given the table: mysql> select * from g2d; +---+--+--+--

combining information from 4 tables into a fifth.

2004-08-10 Thread Jeroen Van Goey
Hey all, I've three tables (g2d, dgp and pocus), with a gene-name, a score and some other information: mysql> select * from dgp; ++---+--+--+++ | chr| start | stop | gene_name | score

placing the OMIM database locally

2003-09-12 Thread Jeroen Van Goey
Hi, I want to put the OMIM databse locally on my computer. I downloaded the file genemap from ftp://ftp.ncbi.nih.gov/repository/OMIM/ It contains a list of fields, separated by the '|' character. An example is: 1.1|9|11|95|1pter-p36.13|CCV|P|Cataract, congenital, Volkmann type||115665|Fd|linked to