[ensembl-dev] EnsemblGenomes data error of ftp resource

[陈岗]

Hi All

During importing Genomes (release-13) data, I suffer some SQL error.

1 In  toxoplasma_gondii_core_13_66_1.sql

 the command:                   "CREATE ALGORITHM=UNDEFINED SQL SECURITY
INVOKER VIEW `exon_stable_id` AS (select `exon`.`exon_id` AS
`exon_id`,`exon`.`stable_id` AS `stable_id`,`exon`.`version` AS
`version`,`exon`.`created_date` AS `created_date`,`exon`.`modified_date` AS
`modified_date` from `exon`); "           returns             "ERROR 1146
(42S02): Table 'toxoplasma_gondii_core_13_66_1.exon' doesn't exist"

the command:                      "CREATE ALGORITHM=UNDEFINED SQL SECURITY
INVOKER VIEW `translation_stable_id` AS (select
`translation`.`translation_id` AS
`translation_id`,`translation`.`stable_id` AS
`stable_id`,`translation`.`version` AS
`version`,`translation`.`created_date` AS
`created_date`,`translation`.`modified_date` AS `modified_date` from
`translation`)
;"               returns           "ERROR 1146 (42S02): Table
'toxoplasma_gondii_core_13_66_1.translation' doesn't exist"

>From ftp downloading site:
ftp://ftp.ensemblgenomes.org/pub/protists/release-13/mysql/toxoplasma_gondii_core_13_66_1/,
I doesn't see those two tables.

How to fix them?

Thanks
-- 
Gang Chen
TILSI
Taicang Institute For Life Science Information
Address: A2/162, Renmin South Road, Taicang, 215400, Jiangsu Province,
P.R.China
Phone:（+86）512-82782588
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.ensembl.org/pipermail/dev_ensembl.org/attachments/20120314/35c17bae/attachment.html>