Jump to content


Photo

The Heck?


  • Please log in to reply
14 replies to this topic

#1 WinnieThePujols

WinnieThePujols
  • Members
  • PipPip
  • Member
  • 21 posts

Posted 02 June 2006 - 01:40 AM

For some reason, two tables from the same database where completely wiped out. I have no idea how this happened. There were other tables in the same database that were completely unaffected...

I do know that one guy had access to both of them (and would have been the most recent to use them), but he would have had no malicious intent and is no where near saavy-enough to have done anything... and any access he had to them would have been purely through web-based applications that I made for him. He can only add stuff through them, too... he can't delete.

Any idea what could have happened? When I run...

"SELECT * FROM literature.recaps r;"

In the query browser, I get:
"The query could not be executed."
And just beneath that part is..
"! Can't find file: 'recaps.MYI' (errno: 2)


Thanks for the help. Not really a big loss if these are gone, but I'd like to know what could have went wrong so I can prevent anything like that from happening again.

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 02 June 2006 - 02:30 AM

Wiped out how? The MYD files didn't vanish, right? If the index is corrupted, that can be fixed. Please clarify.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#3 WinnieThePujols

WinnieThePujols
  • Members
  • PipPip
  • Member
  • 21 posts

Posted 02 June 2006 - 04:16 AM

[!--quoteo(post=379234:date=Jun 1 2006, 09:30 PM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ Jun 1 2006, 09:30 PM) View Post[/div][div class=\'quotemain\'][!--quotec--]
Wiped out how? The MYD files didn't vanish, right? If the index is corrupted, that can be fixed. Please clarify.
[/quote]

"SELECT * FROM recaps r;" returns..
[img src=\"http://img85.imageshack.us/img85/3728/error8tf.jpg\" border=\"0\" alt=\"IPB Image\" /]

I guess I don't know how to answer that. Where are the MYD files stored, phsyically-speaking? I don't know how to check that through like an FTP. I've always used GUI programs like the Query Browser so I don't really know.

But anyway, the screenshot it when I try to query the table and get all of the rows.. and it says it can't be executed.


Edit:
Well, I dd some looking into it. It says that if other repair methods don't work (a missing .MYI) I could try this:

REPAIR TABLE literature.06draft USE_FRM


Unfortunately, it doesn't work... it errors out!

#4 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 02 June 2006 - 02:53 PM

Well, if the table shows up in the DB listing, the underlying file is still there -- why don't you run some checks (using CHECK TABLE EXTENDED) and post the output. We'll get to the bottom of this.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#5 WinnieThePujols

WinnieThePujols
  • Members
  • PipPip
  • Member
  • 21 posts

Posted 02 June 2006 - 06:51 PM

Attempt #1:
[img src=\"http://www.cardsbaseball.net/Clipboard01.jpg\" border=\"0\" alt=\"IPB Image\" /]


Attempt #2:
[img src=\"http://www.cardsbaseball.net/error2.jpg\" border=\"0\" alt=\"IPB Image\" /]


I don't know what to do!

;_;

#6 WinnieThePujols

WinnieThePujols
  • Members
  • PipPip
  • Member
  • 21 posts

Posted 02 June 2006 - 08:27 PM

See I'm reading up on this, but I don't understand why the USE_FRM repair doesn't work. This is from the MySQL site:

[!--quoteo--][div class=\'quotetop\']QUOTE[/div][div class=\'quotemain\'][!--quotec--]There is also a USE_FRM mode available for REPAIR TABLE. Use this if the .MYI index file is missing or if its header is corrupted. In this mode, MySQL re-creates the .MYI file using information from the .frm file. This kind of repair cannot be done with myisamchk. Note: Use this mode only if you cannot use regular REPAIR modes. The .MYI header contains important table metadata (in particular, current AUTO_INCREMENT value and Delete link) that are lost in REPAIR ... USE_FRM. Don't use USE_FRM if the table is compressed because this information is also stored in the .MYI file.[/quote]

Given that I'm getting the missing "06draft.MYI" error, I'm kinda at a loss as to why this isn't working.

#7 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 03 June 2006 - 03:19 AM

I have no idea. My suggestion would be to copy your table to a new table (with INSERT INTO...SELECT WHERE), then add back any indexes that you required from your original table, and then drop the original table. Obviously, after backing everything up.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#8 WinnieThePujols

WinnieThePujols
  • Members
  • PipPip
  • Member
  • 21 posts

Posted 04 June 2006 - 08:00 AM

Do these screenshots help whatsoever?

[img src=\"http://img124.imageshack.us/img124/4509/picy8uk.jpg\" border=\"0\" alt=\"IPB Image\" /]


And this...

[img src=\"http://img79.imageshack.us/img79/8599/picx1dd.jpg\" border=\"0\" alt=\"IPB Image\" /]


Sorry if they're big.. but they just show up as "views." I'm guessing that won't help at all, but I thought it was worth a try.

#9 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 04 June 2006 - 04:59 PM

These are VIEWs? That does make a difference -- what is their underlying table? How were they created?
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#10 WinnieThePujols

WinnieThePujols
  • Members
  • PipPip
  • Member
  • 21 posts

Posted 05 June 2006 - 02:36 AM

I think they somehow became views when they were messed up...

I know I created every table the same way... so in theory, they all should have been the same type.

I'm wondering if there was a known problem where problem X somehow causes tables to change into a view or something.

#11 WinnieThePujols

WinnieThePujols
  • Members
  • PipPip
  • Member
  • 21 posts

Posted 05 June 2006 - 03:24 AM

Edit: nevermind. I can't figure out how to delete this post.

#12 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 05 June 2006 - 03:38 PM

Sounds like you fixed the problem... I'm curious as to what it was in the end.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#13 WinnieThePujols

WinnieThePujols
  • Members
  • PipPip
  • Member
  • 21 posts

Posted 06 June 2006 - 05:57 AM

It's funny that you say that... the reason I edited the post was just because I didn't feel it was relevant at all. I can't even remember what I posted.

I tried doing a lot of different things... I tried backing up the database into a text file hoping there would be just "raw" data, but it was completely empty.

You wanna hear the strangest part?

Today it randomly fixed itself. I honestly have no clue what happened... I like it, though!

Thanks, fenway, for your help. Any time I come here you always lend a helping hand. How this fixed itself I do not know (I checked last night and it wasn't working, but when I got off work tonight it was fine... maybe my host did something?), but it's a nice surprise... it saved me a lot of work!

#14 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 06 June 2006 - 05:18 PM

Well, magic can be good -- let's just hope this problem doesn't resurface.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

#15 WinnieThePujols

WinnieThePujols
  • Members
  • PipPip
  • Member
  • 21 posts

Posted 06 June 2006 - 07:43 PM

I'm thinking maybe my host did something? I don't know what, though. I emailed them asking how I could get access to browse the area where the MYI files would be... they never replied, though.

Regardless, I've started doing the occasional backup of my databases so that if it DOES happen, I'll at least be somewhat protected.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users