Tweet
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... ??????
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... ??????
Comment