28 September, 2010

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: