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