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,638
    "I used to be with it, then they changed what it was.
    Now what was it isn't it, and what is it is weird and scary to me.
    It'll happen to you too."

    Grandpa Simpson



    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

  4. $spacer_open
    $spacer_close

Posting Permissions

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