| |
Haven't registered yet? Do it here now!
|
Porndude
Joined: 17 Mar 2007
Posts: 21
|
|
|
 |
|
 |
|
 Posted: Fri Apr 06, 2007 2:36 am Post subject: Query to MySQL Failed: Can't find file: 'boblogs.MYI' (errno |
 |
|
|
 |
|
 |
|
|
|
|
Remember the problem I had before Kaktusan? mysql died within hours of using it... now this..
I noticed my blog hadn't updated all day..
what do you think the deal with this one is?
-pd
Query to MySQL Failed: Can't find file: 'boblogs.MYI' (errno: 2) |
|
|
|
|
|
|
|
Porndude
Joined: 17 Mar 2007
Posts: 21
|
|
|
|
|
|
|
| Posted: Fri Apr 06, 2007 8:04 am Post subject: |
|
|
|
|
|
|
|
|
|
|
Here's what the support tech said..
The backups from yesterday show that the index for that table has been dropped, which is what ERR 2 is. Table 'boblogs' is only 9KB on the backup, we have 6 copies of it from the 28th, 31st, 1st, 2nd, 3rd, and 4th with 1 row. It has been restored.
Only the index file was missing, the data file for boblogs was still on the live mysql server with the same 1 row in it:
copy# strings boblogs.MYD
Adult
http://www.adamsgoe.com/<Adams Garden of Eden - Stolen in 1998. Resurrected in 2007.K
Your Daily Fresh Best of Big Boobs, Phat Booty, MILF, and Solo Girls Portalv
adult blogs, big tits, MILF Hunter, milf, big boobs, phat booty, solo girls, teen amateur girls, pornstars, porn starsF
F d, Y
Garden of Eden
post
sitemap |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Fri Apr 06, 2007 5:12 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
hi there, huh thats pretty strange...
the "boblogs" table got corrupted again for some reason, but there is no point for becoming corrupted, when it is really low used table, and mainly used for reading from it, not for writing or regularly updating. A mysql table generally gets corrupted after pretty frequent updates/deletes for a big number of time, but in the BO case, that table doesn't do anything like that...
Well, as it looks, some of the "indexes" of that table might be causing that for your case. Please go and deleted all indexes for that table and leave only the ID as primary key and watch over if such corruption of the table will happen again..
_________________
Thanks,
Kaktusan
 |
|
|
|
|
|
|
|
Porndude
Joined: 17 Mar 2007
Posts: 21
|
|
|
|
|
|
|
| Posted: Fri Apr 06, 2007 11:22 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
host tech said this..
Can he provide an appropriate query for this:
> >Well, as it looks, some of the "indexes" of that table might be causing
> >that for your case. Please go and deleted all indexes for that table and
> >leave only the ID as primary key and watch over if such corruption of
> >the table will happen again..
I am not comfortable making any assumptions about database structure for software we are not familiar with. Making an incorrect assumption would completely destroy the table.
Thanks. |
|
|
|
|
|
|
|
Atanasis
Owner
Joined: 22 May 2004
Posts: 4284
Location: The Net
|
|
|
|
|
|
|
| Posted: Sat Apr 07, 2007 9:44 am Post subject: |
|
|
|
|
|
|
|
|
|
|
I see, here are the necessary queries to remote the indexes from that table.
ALTER TABLE `boblogs` DROP INDEX category;
ALTER TABLE `boblogs` DROP INDEX url;
ALTER TABLE `boblogs` DROP INDEX last_post;
ALTER TABLE `boblogs` DROP INDEX last_crawl;
ALTER TABLE `boblogs` DROP INDEX tradeinc;
OPTIMZE table `boblogs`;
Let me know how it goes after that...
_________________
Thanks,
Kaktusan
|
|
|
|
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2002 phpBB Group
|
 |
|
 |
| |
