所以我正在尝试 GBrowse,因为我们稍后会用到它。
但后来我得到了这个
------------------------------------------------------------------------------------------------
256000 features loaded in 230.29s ( 1.19s/1000 features)...
Building object tree... 6.78s.47s
Loading bulk data into database.../tmp/feature.12240
DBD::mysql::db do failed: The used command is not allowed with this MySQL version at /usr/local/share/perl/5.14.2/Bio/DB/SeqFeature/Store/DBI/mysql.pm line 571, <GEN0> line 256232.
-------------------- EXCEPTION --------------------
MSG: The used command is not allowed with this MySQL version
STACK Bio::DB::SeqFeature::Store::DBI::mysql::_finish_bulk_update /usr/local/share/perl/5.14.2/Bio/DB/SeqFeature/Store/DBI/mysql.pm:571
STACK Bio::DB::SeqFeature::Store::finish_bulk_update /usr/local/share/perl/5.14.2/Bio/DB/SeqFeature/Store.pm:1505
STACK Bio::DB::SeqFeature::Store::GFF3Loader::finish_load /usr/local/share/perl/5.14.2/Bio/DB/SeqFeature/Store/GFF3Loader.pm:349
STACK Bio::DB::SeqFeature::Store::Loader::load_fh /usr/local/share/perl/5.14.2/Bio/DB/SeqFeature/Store/Loader.pm:354
STACK Bio::DB::SeqFeature::Store::Loader::load /usr/local/share/perl/5.14.2/Bio/DB/SeqFeature/Store/Loader.pm:243
STACK toplevel bp_seqfeature_load.pl:103
------------------------------------------------------------------------------------------------
我尝试按照这里所说的去做:http://www.markhneedham.com/blog/2011/01/18/mysql-the-used-command-is-not-allowed-with-this-mysql-version/,也在该部分http://dev.mysql.com/doc/refman/5.0/en/load-data-local.html
如果您在 Perl 脚本或其他从选项文件读取 [client] 组的程序中使用 LOAD DATA LOCAL,则可以将 local-infile=1 选项添加到该组。但是,为了避免给不理解 local-infile 的程序造成问题,请使用 loose- 前缀指定它:
。所以我现在很绝望 - ubuntu 中有这样的东西吗?因为正如我在 Windows 中看到的那样,您可以在服务管理单元查看器中轻松编辑。我打算做的是在调用启动--local-infile=1
MySQL 服务的脚本/程序时将参数添加到 mysqld 可执行文件中。