Announcement

Collapse
No announcement yet.

post table corrupted...why?

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

  • post table corrupted...why?

    I ran into the problem of my post table being corrupted last night. I fixed it through phpMyAdmin's repair facility, but am wondering how it happened?

    When I checked its status, I got the following:
    serioussam.post check error Wrong bytesec: 0-0-0 at linkstart: 34142112
    serioussam.post check error Corrupt
    When I repaired it, I got the following:
    serioussam.post repair info Wrong bytesec: 0-0-0 at 34142112; Skipped
    serioussam.post repair warning Number of rows changed from 101107 to 101106
    serioussam.post repair status OK
    Running PHP 4.0.6 and MySQL 3.23.32.
    Seriously! - The Definitive Home of All Things Serious
    Seriously! Forums

    To recieve support on these forums, enter your username here.

  • #2
    MySQL isn't fallible and tables get corrupted from time to time. There could be any multitude of reasons that it got corrupted from a bad sector on your drive, a quirk in the OS'es file handling routines, a power surge, brownout, fate, glitches, elves, fairies and gremlins.

    This is why you are encouraged to create backups regularly and why MySQL provides tools for replicating, backing up and repairing your tables and databases.
    Translations provided by Google.

    Wayne Luke
    The Rabid Badger - a vBulletin Cloud demonstration site.
    vBulletin 5 API - Full / Mobile
    Vote for your favorite feature requests and the bugs you want to see fixed.

    Comment


    • #3
      Unfortunately, backing up is rather hard. The backup routine times out using all methods of backup.php. And we don't have telnet access to use mysqldump.
      Seriously! - The Definitive Home of All Things Serious
      Seriously! Forums

      To recieve support on these forums, enter your username here.

      Comment


      • #4
        Have you tried asking your host to do a mysqldump for you? If they don't allow telnet or SSH they should at least be willing to do that for you.

        Comment


        • #5
          Does your host at least allow you to run cron jobs? If so, you can set up regular backups using this. Search these forums for specific examples.
          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
            Cron jobs are a no. I'll try emailing them, but it'd be a pain to have to get them to do it for us every week
            Seriously! - The Definitive Home of All Things Serious
            Seriously! Forums

            To recieve support on these forums, enter your username here.

            Comment


            • #7
              I feel bad for you. Personally I wouldn't have anything to do with a host that didn't allow shell access and cron jobs. There's plenty of quality hosts that do offer these services.
              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


              • #8
                Yea, neither would I, *especially* the host I'm on(Gamespy)...ugh. Not my decision though.
                Seriously! - The Definitive Home of All Things Serious
                Seriously! Forums

                To recieve support on these forums, enter your username here.

                Comment

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