View Single Post
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