Find the answer to your Linux question:
Results 1 to 3 of 3
Hie guys out there. I am running linux ubuntu server for my website. My website database crashed with this error messages: DB function failed with error number 145 Table './cmsmycompany/l2m_session' ...
Enjoy an ad free experience by logging in. Not a member yet? Register.
  1. #1
    Just Joined!
    Join Date
    May 2009
    Location
    South Africa
    Posts
    30

    Website database crashed


    Hie guys out there. I am running linux ubuntu server for my website. My website database crashed with this error messages:
    DB function failed with error number 145
    Table './cmsmycompany/l2m_session' is marked as crashed and should be repaired SQL=SELECT session_id FROM l2m_session WHERE session_id=MD5('7fbe5d447d34103616a0c38c3212183f')
    SQL =
    SELECT session_id FROM l2m_session WHERE session_id=MD5('7fbe5d447d34103616a0c38c3212183f')

    How do i repair the database.

  2. #2
    Penguin of trust elija's Avatar
    Join Date
    Jul 2004
    Location
    Either at home or at work or down the pub
    Posts
    3,526
    What do we want?
    Time machines!

    When do we want 'em?
    Doesn't really matter does it!?


    The Fifth Continent

  3. #3
    Just Joined!
    Join Date
    May 2009
    Location
    South Africa
    Posts
    30
    :~$ sudo myisamchk --safe-recover /var/lib/mysql/cmsmycompany/l2m_session.MYI
    - recovering (with keycache) MyISAM-table '/var/lib/mysql/cmsmycompany/l2m_session.MYI'
    Data records: 31
    Data records: 28
    - Fixing index 1
    -Fixing index 2
    :~$ sudo /etc/init.d/mysql start
    * Starting MySQL database server mysqld [ OK ]
    * Checking for corrupt, not cleanly closed and upgrade needing tables.

    But getting the same crash error, and not cleanly closed any clue for this

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •