SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Guru
    Join Date
    Nov 2000
    Posts
    740
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Crashed mysql tables - data loss?

    I have several tables that have crashed in my mysql database that is for a vbulletin forum. Apparently, there was a power outage at the hosts. The hosts say they can just run a repair on the tables.

    The forum has over a million posts so its a pretty big file.

    What is the risk of data loss?

    Thanks,

    Jon

  2. #2
    Programming Since 1978 silver trophybronze trophy felgall's Avatar
    Join Date
    Sep 2005
    Location
    Sydney, NSW, Australia
    Posts
    16,831
    Mentioned
    25 Post(s)
    Tagged
    1 Thread(s)
    Worst case would be if you end up deciding to restore from a backup - in which case you'd lose whatever changes were made after the backup was taken. Of course you will have taken that into account when you made your backup plan.

    Assuming that the repair runs successfully you will probably only lose data that were actually being updated at the time of the crash and so would probably not need to use a backup.
    Stephen J Chapman

    javascriptexample.net, Book Reviews, follow me on Twitter
    HTML Help, CSS Help, JavaScript Help, PHP/mySQL Help, blog
    <input name="html5" type="text" required pattern="^$">

  3. #3
    SitePoint Wizard webcosmo's Avatar
    Join Date
    Oct 2007
    Location
    Boston, MA
    Posts
    1,480
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Hopefully you do have a backup, in case the database repair fails - that could be possible. Let them do it an hope for the best, worst case you just run the backup and lose only the latest post, asssuming that the site works now somehow...

  4. #4
    SitePoint Guru
    Join Date
    Nov 2000
    Posts
    740
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Ok, thanks for that.


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •