Mysqldump Compress on the Fly
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
SSH
mysqldump Remote Database to Local One
Remote to Local For migrating a remote database, you can dump and pipe the whole database from remote server to local server via ssh tunnel… Read More »mysqldump Remote Database to Local One
MySQL Dump Remote to Local
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
3 Ways to Connect Remote MySQL
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