Backup MySQL Database MySQL provides mysqldump utility to let us dump SQL statements that can recreate the whole database. We can output the SQL statements… Read More »Mysqldump Compress on the Fly
First of all, you have to ensure that SSH command utility has been installed, because Windows does not provide it by default. C:\Users\alex>ssh 'ssh' is… Read More »MySQL Dump Remote to Local
To connect a remote MySQL database from LAN (e.g. 10.1.0.0/16), you need an account for remote accesses like "user01@10.1.%" instead of "user01@localhost". If the two… Read More »3 Ways to Connect Remote MySQL