The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Corrupt tables

Discussion in 'Database Discussions' started by mojamoi, Mar 13, 2011.

  1. mojamoi

    mojamoi Well-Known Member

    Joined:
    Jul 23, 2007
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    16
    i get this when i repair database thru WHM

    Main >> SQL Services >> Repair a MySQL Database

    Repairing wawanka_wa8

    wawanka_wa8.finance_commentmeta
    Error : Incorrect information in file: './wawanka_wa8/finance_commentmeta.frm'
    error : Corrupt
    wawanka_wa8.finance_comments
    Error : Incorrect information in file: './wawanka_wa8/finance_comments.frm'
    error : Corrupt
    wawanka_wa8.finance_links
    Error : Incorrect information in file: './wawanka_wa8/finance_links.frm'
    error : Corrupt
    wawanka_wa8.finance_options
    Error : Incorrect information in file: './wawanka_wa8/finance_options.frm'
    error : Corrupt
    wawanka_wa8.finance_postmeta
    Error : Incorrect information in file: './wawanka_wa8/finance_postmeta.frm'
    error : Corrupt
    wawanka_wa8.finance_posts
    Error : Incorrect information in file: './wawanka_wa8/finance_posts.frm'
    error : Corrupt
    wawanka_wa8.finance_tempposts
    Error : Incorrect information in file: './wawanka_wa8/finance_tempposts.frm'
    error : Corrupt
    wawanka_wa8.finance_term_relationships
    Error : Incorrect information in file: './wawanka_wa8/finance_term_relationships.frm'
    error : Corrupt
    wawanka_wa8.finance_term_taxonomy
    Error : Incorrect information in file: './wawanka_wa8/finance_term_taxonomy.frm'
    error : Corrupt
    wawanka_wa8.finance_terms
    Error : Incorrect information in file: './wawanka_wa8/finance_terms.frm'
    error : Corrupt
    wawanka_wa8.finance_usermeta
    Error : Incorrect information in file: './wawanka_wa8/finance_usermeta.frm'
    error : Corrupt
    wawanka_wa8.finance_users
    Error : Incorrect information in file: './wawanka_wa8/finance_users.frm'
    error : Corrupt
    Done.
     
  2. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,623
    Likes Received:
    21
    Trophy Points:
    38
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Do you have a backup of that database you can try restoring? If the tables are corrupt and will not repair, a backup of the database is the best bet in getting it back in working order.
     
  3. mojamoi

    mojamoi Well-Known Member

    Joined:
    Jul 23, 2007
    Messages:
    186
    Likes Received:
    0
    Trophy Points:
    16
    unfortunately there is no backup.....its a new site of a client , so no much worries, but help wud be good

    may i know what can be done
     
  4. LinuxTechie

    LinuxTechie Well-Known Member

    Joined:
    Jan 22, 2011
    Messages:
    502
    Likes Received:
    2
    Trophy Points:
    18
    cPanel Access Level:
    Root Administrator
    Hey,

    Can you try this mysqlcheck -op database_name from Shell. If this also fails there is no fix other than a backup!
     
    #4 LinuxTechie, Mar 15, 2011
    Last edited: Mar 15, 2011
  5. dave e

    dave e Registered

    Joined:
    Feb 3, 2012
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Website Owner
    I am a joomla user, this morning all our sites crashed with this

    jtablesession::Store Failed
    DB function failed with error number 1034
    Incorrect key file for table 'jos_session'; try to repair it SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '94d5f9a0f9ce6533dc9560b4de9069b9','1328264707','','0','1','0' )
    Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 16 bytes) in /home/wwwlanes/public_html/libraries/joomla/error/exception.php on line 117

    contacted web support, they have upgraded mysql 4x to 5x

    this the response from web support.

    Hi Dave,

    I am very sorry to hear of the problems you have been having with your Joomla installation.

    We sent an email regarding the update to MySQL this morning at 11:24.

    The MySQL update was essential in order for us to keep functionality for our clients up to date (you requested this to happen, but it was postponed).

    If I remember correctly, Joomla requires MySQL v5 to run anyway?

    Have you contacted Joomla on this? I seem to remember you had issues with Joomla when setting up before.

    I can assure you that the MySQL update will not have corrupted your data, it will be the existing Joomla installation that will not be compatible with the new version of MySQL v5.

    If the update corrupted the databases our own Web-Toast website would have gone down too as we use MySQL heavily for our client support system.

    As far as compensation is concerned, it is up to you to keep backups of data, we cannot do this for you. We do, however keep some backups, so if you have corrupted your database when you installed the new version of Joomla, then we may be able to get it back for you.

    We have an external technical support team, if you require them to look at your databases to try to get it up and running?

    Regards,

    Iain Thompson
    Web-Toast
     
  6. cPanelJared

    cPanelJared Technical Analyst
    Staff Member

    Joined:
    Feb 25, 2010
    Messages:
    1,842
    Likes Received:
    18
    Trophy Points:
    38
    Location:
    Houston, TX
    cPanel Access Level:
    Root Administrator
    This is something you will need to work with your Web host to correct. Only your Web host has the access required to help you with this kind of problem on their server.
     
Loading...

Share This Page