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

Reply via email to