Optimize table

[Zenigata]

Hi,
I tried to optimize a table via phpmyadmin but I have this error:

jwwwazen_forum.phpbb_sessions
error : The handler for the table doesn't support repair

What can I do?

Thanks

[Vin DSL]

Have you tried 'repair' yet?

[Zenigata]

Have you tried 'repair' yet?

Yes, I've tried to repair the table but the error is the same:

jwwwazen_forum.phpbb_sessions
error : The handler for the table doesn't support repair

I've also noticed my database is very slow

phpbb_sessions type: HEAP dimension: 318,0 KB 8.664 Bytes

[Ron]

I don't know how much stuff you've got in it, but maybe consider dumping it, with structure and look at the SQL file generated for any anomalies. Then I might try to create another db and upload that data into the new database and see if it's ok. Then I might consider dropping the bad table and re-creating it.

I should add that I am unfamiliar with that error, and it could be telling you something as simple as an option wasn't specified during creation that could be fixed by a simple alter table command, so I think you're gonna have to try to look up that specific error.

Good luck!

[Ron]

I just googled "The handler for the table doesn't support"

and one of the first results was

http://www.f5hosting.com/forums/arch...php/t-728.html

and it says that it has to be an ISAM-based table to support check/repair. Your post leads me to believe you're trying to fix a heap table, which is a temporary, in-memory table, which I should have picked up on before I suggested you dump the data and rebuild the table. I guess I assumed you had a good reason for trying to optimize a table. My bad.

Of course that's just a forum like this one, so continue your own research from here.

Good luck.