sessions table keeps crashing

[andypandy]

ok sessions table keeps crashing ( 3 times in last 2 wks )

1st and 2nd error:
145 Table './blah/sessions' is marked as crashed and should be repaired
in:
[select value from sessions where sesskey = '25a5b39d0bcb4267f6859d4a3e1b5d47' and expiry > '1241801945']


last error:
126 Incorrect key file for table './blah/sessions.MYI'; try to repair it
in:
[delete from sessions where expiry < 1248164003]

1062 Duplicate entry 'f6c27cc105b45f6feb1f136c12a9c2f3' for key 1
in:
[insert into sessions values ('f6c27cc105b45f6feb1f136c12a9c2f3', '1248165443', '')]


126 Incorrect key file for table './blah/sessions.MYI'; try to repair it
in:
[delete from sessions where expiry < 1248164144]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

1062 Duplicate entry '34f12159906fc241a173e6d71146893d' for key 1


i have been able to repair the table each time in phpmyadmin but its becoming a pain.

i have just upgraded to 1.3.8 but 2 of these crashes happened before upgrade.

php ver 5.2.6

Any help appreciated.

Andy

[data_digger]

Convert it to InnoDB table and crashes will go away.

[andypandy]

thanks just done that... now fingers legs and everything else crossed.

[samuelsmith1979]

I'm a noob to mysql

how do you convert it?

[samuelsmith1979]

found out from my server admin
my mysql instructions were like this

You can convert from MyISAM to InnoDB in phpMyAdmin with just a few clicks. To convert your data tables from MyISAM to InnoDB in phpMyAdmin, you will select the table, click the “Operations” tab, and then choose InnoDB from the drop down box next to the “Storage Engine” type. Click “Go” and you are done!"