Comparison of graphical tools for MySQL
In the world of 95% of web projects using RDBMS MySQL. Of course, every serious project suggests that periodically create a backup copy of all data used in this work. This is a de facto standard approach. Moreover, without this it is impossible to guarantee visitors uptime of your site. If the site provides commercial services, the availability of backup is simply is a necessity.
Making database backups is one of the most important things in the process of administrating MySQL databases, because some critical data loss can be irreplaceable.
Today would be desirable to tell a fairly simple and quite convenient way to automate the daily, weekly and monthly backups process of MySQL databases, which are located on a remote server.
MySQL database located on a remote server hosting provider. Access to MySQL database is permitted through the SSH tunnel.
Settings for the SSH server:
Settings for the MySQL server: