Re: Fail to recover from mysqldump backup file

[Felix Geerinckx]

yudong.sun wrote:

> DROP TABLE IF EXISTS blastn_out;
> CREATE TABLE blastn_out (
> comparison_id int(10) unsigned NOT NULL default
> '0',
> ref_nucleo_id varchar(10) NOT NULL default '',
> qry_nucleo_id varchar(10) NOT NULL default '',
> ref_start int(10) unsigned default NULL,
> ref_end int(10) unsigned default NULL,
> qry_start int(10) unsigned default NULL,
> qry_end int(10) unsigned default NULL,
> score float NOT NULL default '0',
> e_value double NOT NULL default '0',
> qry_strand tinyint(4) default NULL,
> ref_strand tinyint(4) default NULL,
> KEY Primary (comparison_id),
> KEY seqids (ref_nucleo_id,qry_nucleo_id)
> ) TYPE=MyISAM;

It chokes on the "KEY Primary (comparison_id)" part.
If you change this to "Primary KEY (comparison_id)" it should work.

I wonder how it got in there in the first place though...

--
felix