You have learned “How to use SSH to access and manage MySQL database” in the previous article. Take a step further and you are about to automate the database backup process.
Generally, most of the modern hosting platform allows user to access the database using rich user-interface application such as phpmyadmin. Although using the interface is very convenient and easy to use, in some cases you need to use SSH to access and manage your database.
The good thing about having the list is you don’t have to always google about the commands and trial and error every time. You already know what commands will work for specific scenario and it’s reusable and even automatable.
PuTTY is an old school but classic software that allow you to remote ssh your server. It’s a free software application for Windows 95, 98, XP, Vista, and 7 which can be used to make an SSH connection to your server.