* Sinisa Milivojevic > Roger Baklund writes: > > I believe the problem was that this is the ouput of a > > mysqldump... why does mysqldump create invalid CREATE > > statements...? > > Are you sure that the above is the output from mysqldump ?? > > What server version ??
Of course I can not be 100% sure, but this is what Martin wrote originally: * 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 > $ So, unless Martin i joking with us, I would guess it is output from mysqldump, and the version seems to be 3.23.44. (Sorry for the cross quoting) -- 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
