Announcement

Collapse
No announcement yet.

HELLLLLP! Im very close to death :( - error : Can't find file: (errno: 2)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • HELLLLLP! Im very close to death :( - error : Can't find file: (errno: 2)

    MySQL Account Maintenance


    Checking Database
    allsexre_forum is now being checked. allsexre_forum.access
    error : Can't find file: 'access.MYI' (errno: 2)
    allsexre_forum.adminhelp
    error : Can't find file: 'adminhelp.MYI' (errno: 2)
    allsexre_forum.administrator
    error : Can't find file: 'administrator.MYI' (errno: 2)
    allsexre_forum.adminlog
    error : Can't find file: 'adminlog.MYI' (errno: 2)
    allsexre_forum.adminmessage OK
    allsexre_forum.adminutil
    error : Can't find file: 'adminutil.MYI' (errno: 2)
    allsexre_forum.adv_modules OK
    allsexre_forum.adv_pages OK
    allsexre_forum.adv_setting OK
    allsexre_forum.adv_settinggroup OK
    allsexre_forum.announcement
    error : Can't find file: 'announcement.MYI' (errno: 2)
    allsexre_forum.announcementread
    warning : 5 clients are using or haven't closed the table properly
    status : OK
    allsexre_forum.arcade_categories
    error : Can't find file: 'arcade_categories.MYI' (errno: 2)
    allsexre_forum.arcade_challenges
    error : Can't find file: 'arcade_challenges.MYI' (errno: 2)
    allsexre_forum.arcade_games
    error : Can't find file: 'arcade_games.MYI' (errno: 2)
    allsexre_forum.arcade_news
    error : Can't find file: 'arcade_news.MYI' (errno: 2)
    allsexre_forum.arcade_ratings
    error : Can't find file: 'arcade_ratings.MYI' (errno: 2)
    allsexre_forum.arcade_sessions
    error : Can't find file: 'arcade_sessions.MYI' (errno: 2)
    allsexre_forum.attachment
    error : Can't find file: 'attachment.MYI' (errno: 2)
    allsexre_forum.attachmentpermission OK
    allsexre_forum.attachmenttype
    error : Can't find file: 'attachmenttype.MYI' (errno: 2)
    allsexre_forum.attachmentviews
    error : Can't find file: 'attachmentviews.MYI' (errno: 2)
    allsexre_forum.avatar
    error : Can't find file: 'avatar.MYI' (errno: 2)
    allsexre_forum.badwords OK
    allsexre_forum.bbcode
    error : Can't find file: 'bbcode.MYI' (errno: 2)
    allsexre_forum.bot OK
    allsexre_forum.bots OK
    allsexre_forum.calendar
    error : Can't find file: 'calendar.MYI' (errno: 2)
    allsexre_forum.calendarcustomfield
    error : Can't find file: 'calendarcustomfield.MYI' (errno: 2)
    allsexre_forum.calendarmoderator
    error : Can't find file: 'calendarmoderator.MYI' (errno: 2)
    allsexre_forum.calendarpermission
    error : Can't find file: 'calendarpermission.MYI' (errno: 2)
    allsexre_forum.conversationlog OK
    allsexre_forum.cpsession
    note : The storage engine for the table doesn't support check
    allsexre_forum.cron
    error : Can't find file: 'cron.MYI' (errno: 2)
    allsexre_forum.cronlog
    error : Can't find file: 'cronlog.MYI' (errno: 2)
    allsexre_forum.customavatar
    error : Can't find file: 'customavatar.MYI' (errno: 2)
    allsexre_forum.customprofilepic
    error : Can't find file: 'customprofilepic.MYI' (errno: 2)
    allsexre_forum.datastore
    error : Can't find file: 'datastore.MYI' (errno: 2)
    allsexre_forum.deletionlog
    error : Can't find file: 'deletionlog.MYI' (errno: 2)
    allsexre_forum.dstore OK
    allsexre_forum.editlog
    error : Can't find file: 'editlog.MYI' (errno: 2)
    allsexre_forum.event
    error : Can't find file: 'event.MYI' (errno: 2)
    allsexre_forum.externalcache OK
    allsexre_forum.faq
    error : Can't find file: 'faq.MYI' (errno: 2)
    allsexre_forum.forum
    error : Can't find file: 'forum.MYI' (errno: 2)
    allsexre_forum.forumpermission
    error : Can't find file: 'forumpermission.MYI' (errno: 2)
    allsexre_forum.forumread
    error : Can't find file: 'forumread.MYI' (errno: 2)
    allsexre_forum.games_cats OK
    allsexre_forum.games_champs OK
    allsexre_forum.games_league OK
    allsexre_forum.games_list OK
    allsexre_forum.games_savedGames OK
    allsexre_forum.games_scores OK
    allsexre_forum.games_settings OK
    allsexre_forum.gmcache OK
    allsexre_forum.gossip OK
    allsexre_forum.histtd_cats OK
    allsexre_forum.histtd_events OK
    allsexre_forum.histtd_rss
    warning : 1 client is using or hasn't closed the table properly
    status : OK
    allsexre_forum.holiday
    error : Can't find file: 'holiday.MYI' (errno: 2)
    allsexre_forum.icon
    error : Can't find file: 'icon.MYI' (errno: 2)
    allsexre_forum.imagecategory
    error : Can't find file: 'imagecategory.MYI' (errno: 2)
    allsexre_forum.imagecategorypermission
    error : Can't find file: 'imagecategorypermission.MYI' (errno: 2)
    allsexre_forum.infraction OK
    allsexre_forum.infractionban OK
    allsexre_forum.infractiongroup OK
    allsexre_forum.infractionlevel OK
    allsexre_forum.language OK
    allsexre_forum.macro OK
    allsexre_forum.mailqueue
    error : Can't find file: 'mailqueue.MYI' (errno: 2)
    allsexre_forum.moderation
    error : Can't find file: 'moderation.MYI' (errno: 2)
    allsexre_forum.moderator
    error : Can't find file: 'moderator.MYI' (errno: 2)
    allsexre_forum.moderatorlog
    error : Can't find file: 'moderatorlog.MYI' (errno: 2)
    allsexre_forum.passwordhistory
    error : Can't find file: 'passwordhistory.MYI' (errno: 2)
    allsexre_forum.patterns OK
    allsexre_forum.paymentapi
    error : Can't find file: 'paymentapi.MYI' (errno: 2)
    allsexre_forum.paymentinfo
    error : Can't find file: 'paymentinfo.MYI' (errno: 2)
    allsexre_forum.paymenttransaction
    error : Can't find file: 'paymenttransaction.MYI' (errno: 2)
    allsexre_forum.phrase
    error : Can't find file: 'phrase.MYI' (errno: 2)
    allsexre_forum.phrasetype
    error : Can't find file: 'phrasetype.MYI' (errno: 2)
    allsexre_forum.plugin
    error : Can't find file: 'plugin.MYI' (errno: 2)
    allsexre_forum.pm
    error : Can't find file: 'pm.MYI' (errno: 2)
    allsexre_forum.pmreceipt
    error : Can't find file: 'pmreceipt.MYI' (errno: 2)
    allsexre_forum.pmtext
    error : Can't find file: 'pmtext.MYI' (errno: 2)
    allsexre_forum.podcast OK
    allsexre_forum.podcastitem OK
    allsexre_forum.poll
    error : Can't find file: 'poll.MYI' (errno: 2)
    allsexre_forum.pollvote
    error : Can't find file: 'pollvote.MYI' (errno: 2)
    allsexre_forum.post
    warning : 11 clients are using or haven't closed the table properly
    status : OK
    allsexre_forum.post_new
    warning : 1 client is using or hasn't closed the table properly
    warning : Size of indexfile is: 232936448 Should be: 1024
    warning : Size of datafile is: 562167276 Should be: 0
    error : Record-count is not ok; is 1558682 Should be: 0
    warning : Found 1558682 parts Should be: 0 parts
    error : Corrupt
    allsexre_forum.posthash
    error : Can't find file: 'posthash.MYI' (errno: 2)
    allsexre_forum.postindex
    error : Can't find file: 'postindex.MYI' (errno: 2)
    allsexre_forum.postparsed
    error : Can't find file: 'postparsed.MYI' (errno: 2)
    allsexre_forum.product
    error : Can't find file: 'product.MYI' (errno: 2)
    allsexre_forum.productcode
    error : Can't find file: 'productcode.MYI' (errno: 2)
    allsexre_forum.productdependency OK
    allsexre_forum.profilefield
    error : Can't find file: 'profilefield.MYI' (errno: 2)
    allsexre_forum.ranks
    error : Can't find file: 'ranks.MYI' (errno: 2)
    allsexre_forum.regimage
    error : Can't find file: 'regimage.MYI' (errno: 2)
    allsexre_forum.reminder
    error : Can't find file: 'reminder.MYI' (errno: 2)
    allsexre_forum.reputation
    error : Can't find file: 'reputation.MYI' (errno: 2)
    allsexre_forum.reputationlevel
    error : Can't find file: 'reputationlevel.MYI' (errno: 2)
    allsexre_forum.rssfeed OK
    allsexre_forum.rsslog OK
    allsexre_forum.search
    error : Can't find file: 'search.MYI' (errno: 2)
    allsexre_forum.session
    note : The storage engine for the table doesn't support check
    allsexre_forum.setting
    error : Can't find file: 'setting.MYI' (errno: 2)
    allsexre_forum.settinggroup
    error : Can't find file: 'settinggroup.MYI' (errno: 2)
    allsexre_forum.sigparsed
    warning : 8 clients are using or haven't closed the table properly
    status : OK
    allsexre_forum.sigpic OK
    allsexre_forum.smilie
    error : Can't find file: 'smilie.MYI' (errno: 2)
    allsexre_forum.stats
    error : Can't find file: 'stats.MYI' (errno: 2)
    allsexre_forum.strikes
    error : Can't find file: 'strikes.MYI' (errno: 2)
    allsexre_forum.style
    error : Can't find file: 'style.MYI' (errno: 2)
    allsexre_forum.subscribeevent
    error : Can't find file: 'subscribeevent.MYI' (errno: 2)
    allsexre_forum.subscribeforum
    error : Can't find file: 'subscribeforum.MYI' (errno: 2)
    allsexre_forum.subscribethread
    error : Can't find file: 'subscribethread.MYI' (errno: 2)
    allsexre_forum.subscription
    error : Can't find file: 'subscription.MYI' (errno: 2)
    allsexre_forum.subscriptionlog
    error : Can't find file: 'subscriptionlog.MYI' (errno: 2)
    allsexre_forum.subscriptionpermission OK
    allsexre_forum.tachyforumpost
    error : Can't find file: 'tachyforumpost.MYI' (errno: 2)
    allsexre_forum.tachythreadpost
    error : Can't find file: 'tachythreadpost.MYI' (errno: 2)
    allsexre_forum.template
    error : Can't find file: 'template.MYI' (errno: 2)
    allsexre_forum.templatehistory
    error : Can't find file: 'templatehistory.MYI' (errno: 2)
    allsexre_forum.templates OK
    allsexre_forum.thatindex OK
    allsexre_forum.thatstack OK
    allsexre_forum.thread
    error : Can't find file: 'thread.MYI' (errno: 2)
    allsexre_forum.threadrate
    error : Can't find file: 'threadrate.MYI' (errno: 2)
    allsexre_forum.threadread
    error : Can't find file: 'threadread.MYI' (errno: 2)
    allsexre_forum.threadredirect OK
    allsexre_forum.threadviews
    error : Can't find file: 'threadviews.MYI' (errno: 2)
    allsexre_forum.tournament_players OK
    allsexre_forum.tournaments OK
    allsexre_forum.upgradelog
    error : Can't find file: 'upgradelog.MYI' (errno: 2)
    allsexre_forum.user
    error : Can't find file: 'user.MYI' (errno: 2)
    allsexre_forum.useractivation
    error : Can't find file: 'useractivation.MYI' (errno: 2)
    allsexre_forum.userban
    error : Can't find file: 'userban.MYI' (errno: 2)
    allsexre_forum.userfield
    warning : 4 clients are using or haven't closed the table properly
    status : OK
    allsexre_forum.usergroup
    error : Can't find file: 'usergroup.MYI' (errno: 2)
    allsexre_forum.usergroupleader
    error : Can't find file: 'usergroupleader.MYI' (errno: 2)
    allsexre_forum.usergrouprequest
    error : Can't find file: 'usergrouprequest.MYI' (errno: 2)
    allsexre_forum.usernote
    error : Can't find file: 'usernote.MYI' (errno: 2)
    allsexre_forum.userpromotion
    error : Can't find file: 'userpromotion.MYI' (errno: 2)
    allsexre_forum.usertextfield
    error : Can't find file: 'usertextfield.MYI' (errno: 2)
    allsexre_forum.usertitle
    error : Can't find file: 'usertitle.MYI' (errno: 2)
    allsexre_forum.vbplaza_category OK
    allsexre_forum.vbplaza_gift OK
    allsexre_forum.vbplaza_item OK
    allsexre_forum.vbplaza_itemhistory OK
    allsexre_forum.vbplaza_lottery OK
    allsexre_forum.vbplaza_lotteryticket OK
    allsexre_forum.vbplaza_lotterywinner OK
    allsexre_forum.vbplaza_namechange OK
    allsexre_forum.vbplaza_ribbon OK
    allsexre_forum.vbplaza_ribbonitem OK
    allsexre_forum.word
    error : Can't find file: 'word.MYI' (errno: 2)

    Check Complete

    [ Go Back ]

  • #2
    What is the problem w/my db !?!?

    I copied the files from the db folder......my MYI, MYD, and FRM files. There were some MYI and MYD files missing for some tables, but I think thats ok b/c thats how my previous databases were (I think)......

    yes this is mysql 4.1.21

    I been up for 24+ hours straight....back hurts....and everything....tired drooling on the computer :/

    hellllp.

    Comment


    • #3
      Unfortunately you have some serious problems. Something happened to all yourt database index files.

      System error: 2 = No such file or directory

      What are you trying to do and why? In other words, what happened prior to this?
      Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
      Change CKEditor Colors to Match Style (for 4.1.4 and above)

      Steve Machol Photography


      Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


      Comment


      • #4
        Some type of JOURNAL error on the drive. Host said they thought the drive was failing....and so I were to take my files off it. But i didnt make a sql dump -instead they took it down immediately and all i was left with were the files MYI, MYD, and FRM files :/

        I have all my mysql files!

        But yes those MYI files are missing....but they have always been missing. I have a db from a few days back.....and that db works fine. Those files are missing from it too.

        Comment


        • #5
          No they can't always have been missing because your database and forums would not run without them.

          If it's only the MYI files then you can try repairing the database with phpMyAdmin. I don't know if that will work but at this point it is your only hope unless you have a complete backup of the database somewhere.
          Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
          Change CKEditor Colors to Match Style (for 4.1.4 and above)

          Steve Machol Photography


          Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


          Comment


          • #6
            I do have a database back up so I guess I will use that one...

            of course the forums run fine w/o them! do you want to look at my databases? you want to ssh to my server?

            is there a way to import all data/changes into the old database from all tables in the new database that still work? please be aware that these 2 databases are the same up until the 10th of march.

            after that.....the broken database has more posts added, and other changes.

            so is there a way i can like merge the good tables from the bad database to the older working database?

            But you gotta let me know...why is my other database working w/o these MYI files??? And Im in the database right now. Every single table works fine. I believe it has something to do with:

            -rw-rw---- 1 mysql mysql 1721761792 Mar 19 01:27 ibdata1




            How easy is it to merge a OLD and NEW database though. Remember that the new database has new tables, and new data, but also has some old tables and old data. We need to merge the new db back with the old one.

            I guess what I need is something to import all my new data and schema into my old database. What do you think?

            Im going to try to get my mysql files back on my old host and see what I can do then.
            Last edited by eron19; Mon 19th Mar '07, 1:29am.

            Comment


            • #7
              MY OLD DATABASE WITH THE MISSING MYI AND MYD FILES:






              Table Op Msg_type Msg_text
              ------------------------------ ------ -------- ---------------------------------------------------------
              asrcom.word check status OK
              asrcom.vbplaza_ribbonitem check status OK
              asrcom.vbplaza_ribbon check warning 1 client is using or hasn't closed the table properly
              asrcom.vbplaza_ribbon check status OK
              asrcom.vbplaza_namechange check status OK
              asrcom.vbplaza_lotterywinner check warning 2 clients are using or haven't closed the table properly
              asrcom.vbplaza_lotterywinner check status OK
              asrcom.vbplaza_lotteryticket check warning 7 clients are using or haven't closed the table properly
              asrcom.vbplaza_lotteryticket check status OK
              asrcom.vbplaza_lottery check warning 8 clients are using or haven't closed the table properly
              asrcom.vbplaza_lottery check status OK
              asrcom.vbplaza_itemhistory check warning 37 clients are using or haven't closed the table properly
              asrcom.vbplaza_itemhistory check status OK
              asrcom.vbplaza_item check warning 38 clients are using or haven't closed the table properly
              asrcom.vbplaza_item check status OK
              asrcom.vbplaza_gift check status OK
              asrcom.vbplaza_category check status OK
              asrcom.usertitle check status OK
              asrcom.usertextfield check status OK
              asrcom.userpromotion check status OK
              asrcom.usernote check status OK
              asrcom.usergrouprequest check status OK
              asrcom.usergroupleader check status OK
              asrcom.usergroup check status OK
              asrcom.userfield check warning 88 clients are using or haven't closed the table properly
              asrcom.userfield check status OK
              asrcom.userban check status OK
              asrcom.useractivation check status OK
              asrcom.user check status OK
              asrcom.upgradelog check status OK
              asrcom.tournaments check status OK
              asrcom.tournament_players check status OK
              asrcom.threadviews check status OK
              asrcom.threadredirect check status OK
              asrcom.threadread check status OK
              asrcom.threadrate check status OK
              asrcom.thread check status OK
              asrcom.thatstack check status OK
              asrcom.thatindex check status OK
              asrcom.templates check status OK
              asrcom.templatehistory check status OK
              asrcom.template check status OK
              asrcom.tachythreadpost check status OK
              asrcom.tachyforumpost check status OK
              asrcom.subscriptionpermission check status OK
              asrcom.subscriptionlog check status OK
              asrcom.subscription check status OK
              asrcom.subscribethread check status OK
              asrcom.subscribeforum check status OK
              asrcom.subscribeevent check status OK
              asrcom.style check status OK
              asrcom.strikes check status OK
              asrcom.stats check status OK
              asrcom.smilie check status OK
              asrcom.sigpic check status OK
              asrcom.sigparsed check status OK
              asrcom.settinggroup check status OK
              asrcom.setting check status OK
              asrcom.session check note The storage engine for the table doesn't support check
              asrcom.search check status OK
              asrcom.rsslog check status OK
              asrcom.rssfeed check status OK
              asrcom.reputationlevel check status OK
              asrcom.reputation check status OK
              asrcom.reminder check status OK
              asrcom.regimage check status OK
              asrcom.ranks check status OK
              asrcom.profilefield check status OK
              asrcom.productdependency check status OK
              asrcom.productcode check status OK
              asrcom.product check status OK
              asrcom.postparsed check status OK
              asrcom.postindex check status OK
              asrcom.posthash check status OK
              asrcom.post check status OK
              asrcom.pollvote check status OK
              asrcom.poll check status OK
              asrcom.podcastitem check status OK
              asrcom.podcast check status OK
              asrcom.pmtext check status OK
              asrcom.pmreceipt check status OK
              asrcom.pm check status OK
              asrcom.plugin check status OK
              asrcom.phrasetype check status OK
              asrcom.phrase check status OK
              asrcom.paymenttransaction check status OK
              asrcom.paymentinfo check status OK
              asrcom.paymentapi check status OK
              asrcom.patterns check status OK
              asrcom.passwordhistory check status OK
              asrcom.moderatorlog check status OK
              asrcom.moderator check status OK
              asrcom.moderation check status OK
              asrcom.mailqueue check status OK
              asrcom.macro check status OK
              asrcom.language check status OK
              asrcom.infractionlevel check status OK
              asrcom.infractiongroup check status OK
              asrcom.infractionban check status OK
              asrcom.infraction check status OK
              asrcom.imagecategorypermission check status OK
              asrcom.imagecategory check status OK
              asrcom.icon check status OK
              asrcom.holiday check status OK
              asrcom.gossip check status OK
              asrcom.gmcache check status OK
              asrcom.games_settings check status OK
              asrcom.games_scores check status OK
              asrcom.games_savedGames check status OK
              asrcom.games_list check status OK
              asrcom.games_league check status OK
              asrcom.games_champs check status OK
              asrcom.games_cats check status OK
              asrcom.forumread check status OK
              asrcom.forumpermission check status OK
              asrcom.forum check status OK
              asrcom.faq check status OK
              asrcom.externalcache check status OK
              asrcom.event check status OK
              asrcom.editlog check status OK
              asrcom.dstore check status OK
              asrcom.deletionlog check status OK
              asrcom.datastore check status OK
              asrcom.customprofilepic check status OK
              asrcom.customavatar check status OK
              asrcom.cronlog check status OK
              asrcom.cron check status OK
              asrcom.cpsession check note The storage engine for the table doesn't support check
              asrcom.conversationlog check status OK
              asrcom.calendarpermission check status OK
              asrcom.calendarmoderator check status OK
              asrcom.calendarcustomfield check status OK
              asrcom.calendar check status OK
              asrcom.bots check status OK
              asrcom.bot check status OK
              asrcom.bbcode check status OK
              asrcom.badwords check status OK
              asrcom.avatar check status OK
              asrcom.attachmentviews check status OK
              asrcom.attachmenttype check status OK
              asrcom.attachmentpermission check status OK
              asrcom.attachment check status OK
              asrcom.arcade_sessions check status OK
              asrcom.arcade_ratings check status OK
              asrcom.arcade_news check status OK
              asrcom.arcade_games check status OK
              asrcom.arcade_challenges check status OK
              asrcom.arcade_categories check status OK
              asrcom.announcementread check status OK
              asrcom.announcement check status OK
              asrcom.adv_settinggroup check status OK
              asrcom.adv_setting check status OK
              asrcom.adv_pages check status OK
              asrcom.adv_modules check status OK
              asrcom.adminutil check status OK
              asrcom.adminmessage check status OK
              asrcom.adminlog check status OK
              asrcom.administrator check status OK
              asrcom.adminhelp check status OK
              asrcom.access check status OK

              Comment


              • #8
                of InnoDB though the .frm file for the table exists. Maybe you
                have deleted and recreated InnoDB data files but have forgotten
                to delete the corresponding .frm files of InnoDB tables, or you
                have moved .frm files to another database?
                Look from section 15.1 of http://www.innodb.com/ibman.html
                how you can resolve the problem.
                070319 5:06:19 [ERROR] /usr/sbin/mysqld: Can't open file: 'access.ibd' (errno: 1)
                070319 5:06:19 InnoDB error:
                Cannot find table allsexre_forum/access from the internal data dictionary
                of InnoDB though the .frm file for the table exists. Maybe you
                have deleted and recreated InnoDB data files but have forgotten
                to delete the corresponding .frm files of InnoDB tables, or you
                have moved .frm files to another database?
                Look from section 15.1 of http://www.innodb.com/ibman.html
                how you can resolve the problem.
                070319 5:06:19 [ERROR] /usr/sbin/mysqld: Can't open file: 'access.ibd' (errno: 1)









                http://www.innodb.com/innodbtalkCC2004b.pdf
                reading that now.


                It is all of my InnoDB tables that are having this problem.
                Last edited by eron19; Mon 19th Mar '07, 4:02am.

                Comment

                widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                Working...
                X