MySQL Forums
Forum List  »  Newbie

mysqlimport
Posted by: Thomas
Date: July 18, 2005 05:53AM

Hey folks,

I know my question usually causes this nice and warm RTFM-reply, but I hope for some mercy...hey, it's Monday... :-)

simple question: mysqlimport produces lot's of warnings, how to see the details? Is there a log file? Already tried the verbose switch, but no helpful results. As far as I can see the data is written properly into the database, but the warings make me a bit nervous...:)
Some lines from the input file, tab seperated (looks that they are deleted when posting)

Schizosaccharomyces pombe spo:SPCC24E4.01 19076065 \N Q9UUK7 2.1.2.2 K00601
Schizosaccharomyces pombe spo:SPCC569.07 19076066 \N \N 2.6.1.- K00838
Schizosaccharomyces pombe spo:SPCC569.06 19076067 \N \N \N \N
Schizosaccharomyces pombe spo:SPCC569.05c 19076068 \N \N \N \N

table structure:

CREATE TABLE matrix__kegg__main(
serial_kegg_key int(15) NOT NULL AUTO_INCREMENT,
species varchar(50) default NULL,
kegg_id varchar(20) default NULL,
ncbi_id varchar(50) default NULL,
ncbi_gene_id varchar(30) default NULL,
uniprot_id varchar(30) default NULL,
EC varchar(80) default NULL,
kegg_onthology varchar(80) default NULL,
KEY serial_kegg_key (serial_kegg_key)
)TYPE=MyISAM;


Thanks for your help!
Thomas

Options: ReplyQuote


Subject
Written By
Posted
mysqlimport
July 18, 2005 05:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.