Changes to mysqlimport
Owing to problems with BLOB data in some tables, we have had to change the way these tables are dumped, which in turn means a change to the mysqlimport parameters.
It has been necessary to escape the table fields when dumping the MySQL text files. Hence to import successfully, a field escape parameter needs to be specified when using mysqlimport, e.g.
mysqlimport -h your_host -u write_user -p write_pass -P 3306 --fields_escaped_by=\\ database_name /full/path/to/table_name.txt
Tables affected in Release 59 are:
* homo_sapiens_funcgen_59_37d.result_feature
* mus_musculus_funcgen_59_37l.result_feature
* ensembl_compara_59.conservation_scores
and the meta_conf__xml__dm and meta_template__xml__dm tables in all mart databases.
From release 60, all Ensembl mysql dumps will be done this way, so you will need to use the above parameters on all imports.
No comments:
Post a Comment