Hello there, I tried “REPAIR TABLE” to recovery the crushed temp table and that works. Thanks a lot.
But, after reparation, there are some duplicated records generated. Is that because the temp table has no primary key? Or is because the table was crushed in the middle of query? Anyway, I tried to delete the duplicated records. BUT, I can’t. if I just simply delete one of duplicate record, then another one is deleted as well. For instance, there are two duplicate record with qid = 3170, I delete one of them from table, confirm the delete, refresh table, another one disappeared too. Does anyone has any idea about what happened and what should I do to delete duplicate records? Many thanks for any advise. Monet --- "V. M. Brasseur" <[EMAIL PROTECTED]> wrote: > The manual knows all: > > http://dev.mysql.com/doc/mysql/en/REPAIR_TABLE.html > > Cheers, > > --V > > Monet wrote: > > I was working on a table, doing some simple update > on > > table, query is like: > > Update temp > > SET Q1 = 14, > > REVIEWCOMMENTS = CASE WHEN > REVIEWCOMMENTS='WHO2' > > THEN '' > > WHEN REVIEWCOMMENTS LIKE > > '%,WHO2' THEN TRIM(TRAILING ',WHO2' FROM > > REVIEWCOMMENTS) > > WHEN REVIEWCOMMENTS LIKE > > 'WHO2,%' THEN TRIM(LEADING 'WHO2,' FROM > > REVIEWCOMMENTS) > > ELSE > REPLACE(REVIEWCOMMENTS, > > 'WHO2,', '') > > END > > WHERE QID IN > > (3029,3041,3053,3076,3120,3121,3128,3133,3134); > > > > It runs well. Then I did query to pull out all > updated > > records: > > select qid, qd5,q1, reviewcomments > > from temp > > where qid IN > > (3029,3041,3053,3076,3120,3121,3128,3133,3134) > > order by qid asc; > > > > there is no records return. Then I opened temp > table > > found that there is no records at all. But temp > tables > > should contain 67 records. > > I don’t know what happened. Those two queries are > so > > normal and ran several times today. > > Since I have dumped file, I tried to recovery by > run > > dumped sql to restore data into temp table. But > then > > an error message pop up said something like “Table > > handler …got some problem. “ > > So I can’t recovery my temp table in that way. > Further > > more I can’t close Navicat (one mysql interface). > It > > always got an error pop up saying something like > > “memory access violate”. > > > > I restart my computer, reopen temp table, error > > message like this “1016 – can’t open file > temp.MYI. > > (error 145)” showed up and my table lost > everything, > > no data, no columns. > > > > I really have no any experience on this kind of > > situation, please help. Many thanks and much > > appreciated. > > > > Monet > > > > > > > > > > > > __________________________________ > > Do you Yahoo!? > > Yahoo! Mail - 50x more storage than other > providers! > > http://promotions.yahoo.com/new_mail > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
