1 Like
Great podcast! One comment I don't know how people can live without SSH access? I frequently ssh to my site sometimes from my phone. It is much easier to admin things over ssh vs logging into cpanel. For example I had to backup my database prior to installing some things on my site. I ran a script on my laptop and within 30secs I backed up my whole site over ssh. I know there are Wordpress plugins for this and you could backup via the dashboard, problem is like you I have multiple sites. Whenever I run my backup script I just back all of them up, I would not want to login to multiple dashboards.
On the Oh Crud moment you had that allowed you site to be hacked. I once deleted my production database instead of my development one. Oops! Just accidently clicked the wrong line!
@Danny M1 I'm still learning about SSH and I am finding it truly valuable. Can you share what command you ran to back up your site via SSH? I'm interested in learning that one :)
@dhartzler10 Thanks Dustin: Here is the command I use. mysqldump -u[username] -p[password] –host=[dbserver] –all-databases | gzip > ~/database_`date +%m-%d-%Y-%H%M`.sql.gz
Here is the link to my blog post: http://blogmadesimple.com/how-to-backup-database-via-ssh/
This was the first post in my ssh series, I will post the how I do my backup next week.
