Sinisa,
Wow we did it finally:
mysql> create table genpept_sequence_protein
-> select sequence_id, genpept_20010726_113345.* from sequence_protein,
genpept_20010726_113345
-> where sequence_protein.sequence=genpept_20010726_113345.sequence
-> order by sequence_id;
Query OK, 14573 rows affected (4 hours 27 min 55.14 sec)
Records: 14573 Duplicates: 0 Warnings: 0
The number of records equals the select count(*) from the previous table
(lost connection) so I assume the create table statement was successful
after all even after the lost connection. The files sizes seem to confirm
this.
host:/var/db/test% ls -l | grep genpept_sequence_protein
-rw-rw---- 1 plantsp mpr 11127096 Jul 27 14:25
genpept_sequence_protein.MYD
-rw-rw---- 1 plantsp mpr 1024 Jul 27 14:27
genpept_sequence_protein.MYI
-rw-rw---- 1 plantsp mpr 8780 Jul 27 09:57
genpept_sequence_protein.frm
-rw-rw---- 1 plantsp mpr 11127096 Jul 26 18:57
genpept_sequence_protein_lostconnection.MYD
-rw-rw---- 1 plantsp mpr 1024 Jul 26 18:57
genpept_sequence_protein_lostconnection.MYI
-rw-rw---- 1 plantsp mpr 8780 Jul 26 14:13
genpept_sequence_protein_lostconnection.frm
But as you all pointed out one should not bet on it.
Thanks for your input
Hannes
---------------------------------------------------------------------
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