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' ...
- 07-01-2010 #1Just 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.
- 07-03-2010 #2Trusted Penguin
- Join Date
- Jul 2004
- Location
- Either at home or at work or down the pub
- Posts
- 2,301
If we hit that bullseye, the rest of the dominoes will fall like a house of cards. Checkmate! (Zapp Brannigan)
My new blog. It's probably not as good as I think it is.
- 07-03-2010 #3Just 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
Reply With Quote 
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts