#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2001
    Location
    UK
    Posts
    13
    Rep Power
    0

    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
  3. No Profile Picture
    Lost in code
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 2004
    Posts
    8,317
    Rep Power
    7170
    Normally you'll lose a couple rows when running a repair, but since the risk of data loss is 100% if you don't repair it's pretty worthwhile.

    If it's an option, you might want to grab a backup of the data files before attempting the repair.
    PHP FAQ

    Originally Posted by Spad
    Ah USB, the only rectangular connector where you have to make 3 attempts before you get it the right way around
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2001
    Location
    UK
    Posts
    13
    Rep Power
    0
    Ok, thanks for that.

IMN logo majestic logo threadwatch logo seochat tools logo