> On Mon, 28 Jan 2002, Sinisa Milivojevic wrote: > > =?iso-8859-2?Q?Martin MOKREJ=A9?= writes: > > > On Mon, 28 Jan 2002, Sinisa Milivojevic wrote:
Hi, I am retrying to an answer to my question from January. Could please someone from the developers have a look into this? http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:97726:200201:ljpgbhblfacaahpnemag The problem still persists, namely when I try to dump some tables on mysql-3.23.42 (linux binary distrib.), I get: My script: Just dumping Bordetella_pertussis_Tohama_I.nonglob_data ERROR 1064 at line 12: 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 My script: Failed to dump Bordetella_pertussis_Tohama_I.nonglob_data My script: Just dumping Brucella_melitensis_16M.nonglob_data ERROR 1064 at line 12: 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 My script: Failed to dump Brucella_melitensis_16M.nonglob_data My script: Just dumping Brucella_melitensis_16M.scop2_data ERROR 1064 at line 12: 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 My script: Failed to dump Brucella_melitensis_16M.scop2_data The problem is either in mysqld exporting data in wrong format or in mysqld 3.23.47 (see mails from january) or 3.23.49a when importing dumps into the database. The only conclusion from January is that the PRIMARY KEY syntax used in dumps is wrong. Dump of usable table using 3.23.42 client, but the dumps is not importable: # MySQL dump 8.16 # # Host: localhost. Database: Bordetella_pertussis_Tohama_I #-------------------------------------------------------- # Server version 3.23.42-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; Dump of usable table using 3.23.42 client (this dump is importable): # MySQL dump 8.16 # # Host: localhost. Database: Aeropyrum_pernix_K1 #-------------------------------------------------------- # Server version 3.23.42-log # # Table structure for table 'nonglob_data' # CREATE TABLE nonglob_data ( id mediumint(8) unsigned NOT NULL default '0', contig_data_id mediumint(8) unsigned NOT NULL default '0', contig_data_code varchar(100) NOT NULL default '', code varchar(100) NOT NULL default '', descr varchar(255) NOT NULL default '', dat longtext, created varchar(100) default NULL, PRIMARY KEY (id), KEY code (code), KEY descr (descr), KEY contig_data_id (contig_data_id), KEY contig_data_code (contig_data_code) ) TYPE=MyISAM; mysql> use Bordetella_pertussis_Tohama_I; mysql> describe nonglob_data; +------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+--------------+------+-----+---------+-------+ | id | int(11) | | PRI | 0 | | | contig_data_id | int(11) | | MUL | 0 | | | contig_data_code | varchar(100) | | MUL | | | | code | varchar(100) | | MUL | | | | descr | varchar(255) | YES | MUL | NULL | | | dat | longtext | YES | | NULL | | | created | varchar(100) | | | | | +------------------+--------------+------+-----+---------+-------+ mysql> use Aeropyrum_pernix_K1; mysql> describe nonglob_data; +------------------+-----------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+-----------------------+------+-----+---------+-------+ | id | mediumint(8) unsigned | | PRI | 0 | | | contig_data_id | mediumint(8) unsigned | | MUL | 0 | | | contig_data_code | varchar(100) | | MUL | | | | code | varchar(100) | | MUL | | | | descr | varchar(255) | | MUL | | | | dat | longtext | YES | | NULL | | | created | varchar(100) | YES | | NULL | | +------------------+-----------------------+------+-----+---------+-------+ To be sure, I tried to dump same table from same server using client 3.23.42 and 3.23.49a: $ diff Bordetella_pertussis_Tohama_I.nonglob_data.sql-3.23.42 Bordetella_pertussis_Tohama_I.nonglob_dat.sql-3.23.49a 1,5c1,5 < # MySQL dump 8.16 < # < # Host: localhost. Database: Bordetella_pertussis_Tohama_I < #-------------------------------------------------------- < # Server version 3.23.42-log --- > -- MySQL dump 8.21 > -- > -- Host: kulan Database: Bordetella_pertussis_Tohama_I > --------------------------------------------------------- > -- Server version 3.23.42-log 7,9c7,9 < # < # Table structure for table 'nonglob_data' < # --- > -- > -- Table structure for table 'nonglob_data' > -- 53,55c53,56 < # < # Dumping data for table 'nonglob_data' < # --- > -- > -- Dumping data for table 'nonglob_data' > -- > $ Are "--" representing comments? BTW: ftp> cd /pub/mysql/secret 250 CWD command successful. ftp> mkdir mmokrejs 257 "/pub/mysql/secret/mmokrejs" new directory created. ftp> cd mmokrejs 550 mmokrejs: No such file or directory. ftp> cd /pub/mysql/secret/mmokrejs 550 /pub/mysql/secret/mmokrejs: No such file or directory. ftp> cd /pub/mysql/secret 250 CWD command successful. ftp> Please find there: Aeropyrum_pernix_K1.nonglob_data.sql-3.23.42.gz Bordetella_pertussis_Tohama_I.nonglob_dat.sql-3.23.49a.gz Bordetella_pertussis_Tohama_I.nonglob_data.sql-3.23.42.gz Brucella_melitensis_16M.nonglob_data.sql-3.23.42.gz Brucella_melitensis_16M.scop2_data.sql-3.23.42.gz My last questions are: if our developers changed the structure of tables, how did that happen that they coould create a table structure which isn't valid under never version? Which table structure do you consider right? Many 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
