So i seem to regularly have an issue with my databases getting corrupt. Being innoDB i am unable to repair or optimize in phpmyadmin and infact if i do try to repair it just crashes the mysql server all together. Any suggestions on how to better manage this?
He didn't mean command prompt, he said command line.
Use something like putty http://www.chiark.greenend.org.uk/~sgtatham/putty/
Connect using your IP, default port is 22, and you should know your username and password if you're using a VPS or dedicated server. If you are using shared hosting, contact your host.
Just a quick question. I am also trying to run a backup via ssh. I have the command but when prompted for password it does not work. This could be the app I am using as I am using juicessh app on android. But when I go to type password nothing is actually typed. It only seems to be when I am promoted for password after trying to run backup of dB. Again this is all pretty new to me so could be the app but I am not sure.