Error in MySQL Log

[SeLLeRoNe]

I've a problem with mysql...

In the log say that a file nuke_session.MYI does not exist...

How i can repair all databases with ssh command?

Thanks

 

[gcypher]

You cannot, you should import the tables with their info using phpMyAdmin or something familiar.

 

[etechsupport]

If a table has disppeared then you need to restore it from backup.

To repair a database best option is to get into the database directory from SSH like following :-

cd /var/lib/mysql/database_name

and give following command :-

myisamchk -o *.MYI

This will optimize your database and correct problems if there are any.

 

[digi]

If a table has disppeared then you need to restore it from backup.

//edit: Fixed