SEQanswers

Go Back   SEQanswers > Bioinformatics > Bioinformatics



Similar Threads
Thread Thread Starter Forum Replies Last Post
Download UCSC table with mySql workbench desmo Bioinformatics 4 05-31-2012 07:28 AM
1K Genomes mysql ashkot Bioinformatics 0 04-20-2012 11:48 AM
Execute Tophat Via Java Stiff0810 Bioinformatics 6 07-18-2011 12:53 AM
dbSNP build 133 & mysql rworthi Bioinformatics 0 06-30-2011 03:05 PM
another tophat "could not execute prep_reads" error James Bioinformatics 7 11-17-2010 04:49 AM

Reply
 
Thread Tools
Old 06-19-2013, 11:43 AM   #1
kai3192
Junior Member
 
Location: India

Join Date: Jun 2013
Posts: 8
Exclamation DBD::mysql::st execute failed

I am using orthomcl... and currently encountering a error at step 9 (orthomclLoadBlast)... the error says 'DBD::mysql::st execute failed: The used command is not allowed with this MySQL version at orthomclLoadBlast line 39, <F> line 14.'

The orthomcl manual suggests to reinstall Mysql as it was configured without the load local infile tag.... I did that well a several times but when i reinstall the server does not start... i m using ubuntu 12.04... and only when i install the mysql package that comes with ubuntu i m able to start the server but it is by default not configured with Load Local infile option... what should I do ???

I also tried using the mysql import command to directly import the files into the table but then i get an error saying 'mysqlimport: Error: 13, File '/var/lib/mysql/SimilarSequences.txt' not found (Errcode: 13), when using table: SimilarSequences'.... although when the file is persent at its printed path

Can anybody please help me... ??????
kai3192 is offline   Reply With Quote
Old 06-24-2013, 01:26 AM   #2
Shishir
Member
 
Location: Germany

Join Date: Nov 2012
Posts: 22
Default

Hi, I am facing the same error and still not able to solve it. Have you already fixed this error?
Shishir is offline   Reply With Quote
Reply

Tags
dbi, mysql, orthomcl, orthomclloadblast

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off




All times are GMT -8. The time now is 03:38 PM.


Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2020, vBulletin Solutions, Inc.
Single Sign On provided by vBSSO