* Martin MOKREJŠ
> 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?
I don't know why this happens, but read below...
> 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),
The error message suggests the problem is in the above line. From the
documentation:
create_definition:
col_name type [NOT NULL | NULL] [DEFAULT default_value] [AUTO_INCREMENT]
[PRIMARY KEY] [reference_definition]
or PRIMARY KEY (index_col_name,...)
or KEY [index_name] (index_col_name,...)
or INDEX [index_name] (index_col_name,...)
or UNIQUE [INDEX] [index_name] (index_col_name,...)
or FULLTEXT [INDEX] [index_name] (index_col_name,...)
or [CONSTRAINT symbol] FOREIGN KEY [index_name] (index_col_name,...)
[reference_definition]
or CHECK (expr)
You can have "UNIQUE", "KEY" or "PRIMARY KEY", but not all at the same
time...
I have no idea why mysqldump creates this statement. But there is more...
> 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),
Why are there multiple indexes for the same fields?
> 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;
A lot of them, actually... can anyone explain this?
--
Roger
---------------------------------------------------------------------
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
