oh sorry by command line I meant an ssh connection to my website sorry!

I did go into myphpadmin and clicked the configuration table and then the repair link but didnt work

Would it be worthwhile backing up, deleting the database and recreating?