How to backup a large mysql database with innodb tables (85GB) if there is 7GB of disk space left?

Question

MySQL

I would like to use Percona XtraBackup (so as not to lock the database, maybe there are other options?) And make, for example, a network drive using sshfs. The only problem is that debian is installed on the server where you need to backup the database, and I plan to send backups to my home computer with windows 7, so sshfs will not help here. The filezilla server is already installed and configured on the home computer, so, of course, ideally it would be to make backups here via ftp. Can you suggest the best way to do it?

Answer 1

Something like this you can try.
Or a compression option to save traffic and disk space at the destination.
UPD. FTP option (requires ncftp utility set).

mysqldump -uname -ppass db | gzip -c | ncftpput -u login -p pass -c host /db.gz

Answer 2

"Gentlemen - you are beasts, gentlemen!" (c) "Cruel romance"
Pouring somewhere in realtime backup from the database server to another host is a perversion of the highest level! (... and balances on the verge of poverty)
Or, if you do this, you will need to add a check that the backup is valid (like trying to deploy the database from the backup after creation ...)
A simple example: at the time of creating the backup, the network connection disappears for a short time (and possibly many times ... the magnitude of the disappearance of communication between hosts - from a few milliseconds to 1-3 seconds ...). There is a possibility that the backup program will not have time to "react" to such collisions and upon completion of the process it will show that the backup has been successfully created! Although such a backup copy is immediately in the trash ...
For a reasonable algorithm has already been written out with the blood of more than one generation of admins: a "local" backup copy is created and then poured onto the required host ... At current prices for SATA screws (a dozen per bucket!) - it's wiser to buy and install the cheapest SATA- screw, than to engage in perversions, IMHO ...

Answer 3

Attach port 3306/tcp to your local computer via ssh from the server and access from your machine as a local muscle, backup immediately to your machine.

Answer 4

Take VDS in VScale for a short time, install nix virtually on your Windows, increase your data plan (if you have VDS)....