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]
