TechnoTony Wiki - Tony Tascioglu's personal public knowledge-base! https://wiki.tonytascioglu.com/ 2026-04-12T02:08:06+00:00 https://wiki.tonytascioglu.com/ https://wiki.tonytascioglu.com/_media/wiki/logo.png text/html 2023-01-15T23:11:00+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.tonytascioglu.com/scripts/backups/dump_mysql_over_ssh?rev=1673824260 Dump and Backup a MySQL Database over SSH To do pull-backups of MySQL database tables from a server over SSH, I've found that just piping the data over SSH similar to how you would to run TAR over SSH works surprisingly well. Depending on whether you use password with your database, or, rely on unix authentication, you will need to either use -p after the -u root or sudo. text/html 2023-01-15T23:13:06+00:00 Anonymous (anonymous@undisclosed.example.com) https://wiki.tonytascioglu.com/scripts/backups/tar_over_ssh?rev=1673824386 TAR a system over SSH Here is a sample command. You may need sudo/access to files/etc. I assume you can sort that out. ssh user@host sudo tar -cvpf - --one-file-system / > backup-(date +%Y-%m-%d--%H-%M).tar This will print the file list to you over stdout, and create a tar file piped to your local system with the root filesystem. Simple and effective to back up a VPS. SSH is encrypted, so this should be fine from that regard.