Need urgent help

Discussion in 'MySQL' started by max pain, Aug 16, 2007.

Thread Status:
Not open for further replies.
  1. #1
    Hi mates,
    I need help from fellow DB experts to fix an issue with my database:

    I have moved servers and the db was working fine except for a few cronjob errors and now I have this error - which is not getting fixed at all.

    The size of the DB is huge so plz do not mess around if you dont know what you are doing.... I will pay (plz quote reasonably) ;)

    PM me if you are confident of doing this.
     
    max pain, Aug 16, 2007 IP
  2. Roido

    Roido Active Member

    Messages:
    273
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    60
    #2
    You should manually try and repair it from the mysql console.

    mysql -p -u root
    use database dbname
    repair table tablename

    Edit: Also if you do not have shell access - you should repair it from phpmyadmin.

    This should solve the problem.
     
    Roido, Aug 16, 2007 IP
    max pain likes this.
  3. Coder

    Coder Banned

    Messages:
    311
    Likes Received:
    8
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Yes

    mysql -p -u root
    use database dbname
    repair table tablename

    This would the solution only here....
     
    Coder, Aug 16, 2007 IP
    max pain likes this.
  4. cyanide

    cyanide Peon

    Messages:
    483
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Do you have root access to the server? You will need that in order to repair the database, And with a large database, phpmyadmin won't cut it.
     
    cyanide, Aug 16, 2007 IP
    max pain likes this.
  5. max pain

    max pain Notable Member

    Messages:
    2,179
    Likes Received:
    521
    Best Answers:
    0
    Trophy Points:
    260
    #6
    Thanks for your advice and suggestions guys, the DB has been fixed :)
     
    max pain, Aug 16, 2007 IP
Thread Status:
Not open for further replies.