1. Advertising
    y u no do it?

    Advertising (learn more)

    Advertise virtually anything here, with CPM banner ads, CPM email ads and CPC contextual links. You can target relevant areas of the site and show ads based on geographical location of the user if you wish.

    Starts at just $1 per CPM or $0.10 per CPC.

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.