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:
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.