<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style id="owaParaStyle" type="text/css">
<!--
p
{margin-top:0;
margin-bottom:0}
-->
P {margin-top:0;margin-bottom:0;}</style>
</head>
<body ocsi="0" fpstyle="1">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;">
<div style="direction:ltr; font-family:Tahoma; color:#000000; font-size:10pt">Hi all,<br>
<br>
I'm getting the following error when I try to load compressed_genotype_region table on homo_sapiens_variation_75_37 database.<br>
<br>
> mysqlimport -u username -p --fields_escaped_by=\\ homo_sapiens_variation_75_37 -v -d -L compressed_genotype_region.txt<br>
> Enter password: <br>
> Connecting to localhost<br>
> Selecting database homo_sapiens_variation_75_37<br>
> Deleting the old data from table compressed_genotype_region<br>
> Loading data from LOCAL file: /data/compressed_genotype_region.txt into compressed_genotype_region<br>
> mysqlimport: Error: 1034, Wrong bytesec: 0- 0- 0 at 163760275876; Skipped, when using table: compressed_genotype_region<br>
<br>
System : Ubuntu 14.04<br>
MySQL : 5.5.38-0ubuntu0.14.04.1<br>
Ensembl : release 75<br>
<br>
Is this due to corruption on file itself or some sort of encoding issue? I was able to successfully load homo_sapiens_core_75_37 and homo_sapiens_funcgen_75_37 databases using the generic command "mysqlimport -u username -p --fields_escaped_by=\\ Database Name
-L *.txt". <br>
For homo_sapiens_variation_75_37, I was able to successfully load all tables except compressed_genotype_var table which I'm also getting a similar Wrong bytesec error.<br>
<br>
Thanks in advance!<br>
<br>
David<br>
</div>
</div>
</body>
</html>