I have filled my disk completelly and i damaged my phpwebgallery_images table.
I now reduce the amount of pictre on the disk but the database is now giving an error:
SELECT path, tn_ext
FROM phpwebgallery_categories AS c INNER JOIN phpwebgallery_images AS i
ON i.id = c.representative_picture_id
WHERE uppercats REGEXP '(^|,)1(,|$)'
ORDER BY RAND()
LIMIT 0,1
;
[mysql error 1016] Can't open file: 'phpwebgallery_images.MYI' (errno: 145)

i am using a free eos server 1.3 and it doesn't use phpmyadmin, how can i fix my table with mysql?

Does phpwebgallery_images.MYI even exist in /var/lib/mysql directory? You can try to repair the table but from the sounds of the error, you're probably best off to reload from a backup. No backups and repair doesn't work you say, well, looks like you'll be redoing your gallery and after you're done, setup a good backup plan for the database..

You can try to repair a table with the following SQL:

mysql> REPAIR TABLE phpwebgallery_images;

That's if the table name is called phpwebgallery_images

myisamchk --check /var/lib/mysql/phpwebgallery_images.MYI once that is done it will give you a summary of the issues. Then you can run myisamchk --safe-recover /var/lib/mysql/phpwebgallery_images.MYI

Remember though, that will only work if the file actually exists..