Hie guys out there. I am running ubuntu server for my website.When i logon to my website I am getting this 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 and not all that good with sql but i can walk around easily.

Hi

I've had the same problem, it can happen if you have a powerout or something. It usually means some index file is corrupt.

Stop mysql:
sudo /etc/init.d/mysql stop

Let myisamchk fix it:
sudo myisamchk --safe-recover /var/lib/mysql/databasename/tablename.MYI

(Change databasename and tablename to the proper names. From the error message, it looks like your database is cmsmycompany and your table is l2m_session)

Start mysql again:
sudo /etc/init.d/mysql start

When I run myisamchk fix i get an error message that '/var/lib/mysql/databasename/tablename.MYI does not exist. When i restart the mysql I am getting not cleanly closed as follows:

sudo /etc/init.d/mysql start
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.

how do i clear this.

The path to the file is wrong then. I would try to search for the file that needs fixing:

sudo locate l2m_session

If it outputs the .MYI a file, that's the filename to use for myisamchk. The message you get when restarting mysql is normal, but it doesn't always fix it automatically.

Well after searching of the file I copy it and run the myisamchk and get the following output:-

perfectpol7:~$ 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
perfectpol7:~$ sudo /etc/init.d/mysql start
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.

But this seems not to repair, because I am still getting the same error. Is there anything should be done after running the myisamchk