MySQL REPAIR DATABASE function

Discussion in 'Site & Server Administration' started by eniram, May 23, 2007.

0
  1. #1
    Anyone have any pointers on using the MySQL REPAIR DATABASE functions.
    One of our database tables is corrupt and the particular software provider has recommended using MySQL REPAIR DATABASE feature?
     
    eniram, May 23, 2007 IP
  2. Clark Kent

    Clark Kent Guest

    Messages:
    122
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #2
    Backup your table (If you are using myIsam, just copy your table files to somewhere else). Than execute "repair table yourtablename".
    Mostly table corruptions are on index files and easyly recoverable.
    Unexpected shutdowns or disk space problems may have results like this.
    Hope you resolve your problem easy.
     
    Clark Kent, May 23, 2007 IP
  3. eniram

    eniram Peon

    Messages:
    220
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Thank you Clark Kent!
    This is somewhat new to me and I sincerely appreciate your help.

    I'm stuck now at:
    [root@u00000000 root]# shell> mysqlrepair --repair bbllc_jolly

    I'm using PUTTY to access, what am I missing?
     
    eniram, May 23, 2007 IP
  4. Clark Kent

    Clark Kent Guest

    Messages:
    122
    Likes Received:
    11
    Best Answers:
    0
    Trophy Points:
    0
    #4
    Do you have phpmyadmin or another frontend application?
    You may try executing queries with phpmyadmin.
    If you know which tables are corrupted, I suggest to use "repair table" command on that tables.

    Also documantation about repairing.
    http://dev.mysql.com/doc/refman/5.0/en/mysqlcheck.html
     
    Clark Kent, May 23, 2007 IP
  5. cyanide

    cyanide Peon

    Messages:
    483
    Likes Received:
    26
    Best Answers:
    0
    Trophy Points:
    0
    #5
    Login to shell, and put

    when complete, then do
     
    cyanide, May 23, 2007 IP
  6. wahyu

    wahyu Peon

    Messages:
    75
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #6
    Yes, i found that the function is usefull, but if you have a serious crash, some data will be truncated.
     
    wahyu, May 11, 2008 IP
  7. fisherking

    fisherking Peon

    Messages:
    104
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #7
    fisherking, Aug 18, 2009 IP
  8. khucthuydu

    khucthuydu Member

    Messages:
    52
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    41
    #8


    dont work with me,

    can i use VPS 500MB ram with mysqldatabase 1GB
     
    khucthuydu, Sep 18, 2010 IP
  9. 123addme

    123addme Active Member

    Messages:
    171
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    58
    #9
    It's work but very slow.
     
    123addme, Sep 19, 2010 IP
  10. tanvisharma

    tanvisharma Peon

    Messages:
    62
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #10
    You can repair & restore your corrupt MySQL database table by an advanced Stellar MySQL repair utility. It is read only in nature and successful restore table corruption in MySQL database. You can download free demo version to see the preview of your corrupt table.
     
    tanvisharma, May 9, 2011 IP
  11. addisionphilip

    addisionphilip Member

    Messages:
    15
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    36
    #11
    There is a 3rd party software that claims it can repair & recover data from corrupt MySQL database.
    www.mysql-database-recovery.com
    Good Luck!!!
     
    addisionphilip, May 7, 2014 IP