I logged in my server via SSH and committed a "repair table xxx" query on a MyISAM table with 34 million rows and 69GB of data. Unfortunately the SSH connection was lost. When I logged back in I found the mysql -u xxx -p session was gone by 'ps a'. The disk mount is now fully occupied and is not released. So I suppose a repair again would correct all this?
I want to use cron job to run this remotely rather than from SSH which can possibly be disconnected again. After finding this page:
I see it's possible to run repair table via command line like this:
mysqlcheck --repair --databases db_name ...
But how can I just --repair a specific table in the database db_name? Any other tips regarding how I can correct this mess would be much appreciated!