Other posts about mysqldump Our colleagues over at maxcluster told us a while ago, that the best way to migrate a (My)SQL or database or MaraDB ist to use the mysqldump tool which comes with the server we want to import into. They are normally most compatible to each other and can read most of […]

Other posts about mysqldump There are plenty of explanations how to run a MySQL dump via an SSH tunnel, but none of them was extensive enough for me, so I try it on my own. SSH Tunnel First log into the machine you want the sql dump to show up. As described in the next […]

Other posts about mysqldump mysqldump –quick -C –hex-blob –single-transaction –quick, -q This option is useful for dumping large tables. It forces mysqldump to retrieve rows for a table fromthe server a row at a time rather than retrieving the entire row set and buffering it in memorybefore writing it out.–compress, -C Compress all information sent […]