Fix Corrupt Database?

Discussion in 'Databases' started by ks2007, Jul 23, 2007.

  1. #1
    My database seems to of got corrupt over night. I sent a support ticket to Dreamhost this morning but have not recieved a reply. I tried loggin in via PHPMyAdmin and my user/pass is not recognised even though in the account settings both are still their. I made a new testing account which works but it does not load the table. When i click the table to load the status bar just says loading and nothing else....

    So my next option is to check/repair the database via shell but I dont know how to... I tried to google it but they didnt have a dummies guide that I could use...

    So if anyone can help would be useful :)

    Its a IPB forum that has been corrupted the IPB site itself does'nt say what the exact error is except that its a DB error...
     
    ks2007, Jul 23, 2007 IP
  2. roseau

    roseau Peon

    Messages:
    266
    Likes Received:
    9
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Well I think the first thing is to find out how the password got changed and why. I would not go to the trouble to repair the DB yet in the event it just gets corrupted again.

    Further a lot of hosts won't let you SSH into the server due to security risks.

    Can you phone these people to escalate your service ticket?

    I know this obvious but in trying to access the DB through PHPMY, are you using case sensitive letters?

    PS - I just thought of something else - are you able to make a new DB with new info and get logged into PHPMYand do you have a current back up of the DB
     
    roseau, Jul 23, 2007 IP
  3. cyanide

    cyanide Peon

    Messages:
    483
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Tell your host to run from shell
    and then
    That should repair and optimize your database
     
    cyanide, Jul 23, 2007 IP