Re: Fail to recover from mysqldump backup file
Posted by:
yudong.sun
Date: April 19, 2005 03:31AM
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;