Hi,
  I have a problem to re-import sql dump from Linux 2.2.19 running
mysql  Ver 11.15 Distrib 3.23.44, for pc-linux-gnu (i686)

into the same mysqld under different database.

  while running the same commandline on the source at least.

$ mysqldump --extended-insert Bordetella_pertussis_Tohama_I nonglob_data | mysql mmo
ERROR 1064 at line 11: You have an error in your SQL syntax near 'PRIMARY (id),
  KEY contig_data_id (contig_data_id),
  KEY contig_data_id_2 (con' at line 9
$ 

Could someone explain me where is the error?


The dump looks like:

$ mysqldump --extended-insert Bordetella_pertussis_Tohama_I nonglob_data | less
# MySQL dump 8.16
#
# Host: xxx    Database: Bordetella_pertussis_Tohama_I
#--------------------------------------------------------
# Server version        3.23.44-log

#
# Table structure for table 'nonglob_data'
#

CREATE TABLE nonglob_data (
  id int(11) NOT NULL default '0',
  contig_data_id int(11) NOT NULL default '0',
  contig_data_code varchar(100) NOT NULL default '',
  code varchar(100) NOT NULL default '',
  descr varchar(255) default NULL,
  dat longtext,
  created varchar(100) NOT NULL default '',
  UNIQUE KEY PRIMARY (id),
  KEY contig_data_id (contig_data_id),
  KEY contig_data_id_2 (contig_data_id),
  KEY contig_data_code (contig_data_code),
  KEY contig_data_id_3 (contig_data_id),
  KEY code (code),
  KEY contig_data_id_4 (contig_data_id),
  KEY descr (descr),
  KEY contig_data_code_2 (contig_data_code),
  KEY contig_data_code_3 (contig_data_code),
  KEY code_2 (code),
  KEY contig_data_code_4 (contig_data_code),
  KEY code_3 (code),
  KEY contig_data_id_5 (contig_data_id),
  KEY contig_data_id_6 (contig_data_id),
  KEY code_4 (code),
  KEY descr_2 (descr),
  KEY descr_3 (descr),
  KEY contig_data_code_5 (contig_data_code),
  KEY contig_data_code_6 (contig_data_code),
  KEY descr_4 (descr),
  KEY contig_data_id_7 (contig_data_id),
  KEY contig_data_id_8 (contig_data_id),
  KEY contig_data_code_7 (contig_data_code),
  KEY contig_data_code_8 (contig_data_code),
  KEY code_5 (code),
  KEY descr_5 (descr),
  KEY code_6 (code),
  KEY code_7 (code),
  KEY descr_6 (descr),
  KEY code_8 (code),
  KEY descr_7 (descr)
) TYPE=MyISAM;

[...]


I've uploaded these two files into /pub/mysql/secret:
Bordetella_pertussis_Tohama_I.nonglob_data.sql.gz
Bordetella_pertussis_Tohama_I.tmhmm_data.sql.gz

Thanks. Please Cc: me in replies.
-- 
Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs
MIPS / Institute for Bioinformatics <http://mips.gsf.de>
GSF - National Research Center for Environment and Health
Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany
tel.: +49-89-3187 3616 , fax: +49-89-3187 3585



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to