How to backup big mysql database with innodb tables (85GB), if disk space is left 7ГБ?

I would like to use Percona XtraBackup (not great security database, maybe there are other options?) and make, for example, on a network drive with sshfs. The only problem is that the server where you have to make a backup of the database installed debian, and I plan to send the backups yourself on a home computer with windows 7, respectively sshfs will not help here. On the home computer is already installed and configured filezilla server, so, of course, the ideal would be to make a backup via ftp here. Can you tell me how to do?
July 9th 19 at 13:22
4 answers
July 9th 19 at 13:24
Solution
Something you can try.
mysqldump -uname-ppass db | ssh -C user@host 'cat > /path/db.sql'

Or with compression, to save bandwidth and disk space at the destination.
mysqldump -uname-ppass db | gzip -c | ssh login@host 'cat > /path/db.gz'


UPD. Option with FTP (requires ncftp utilities).
mysqldump -uname-ppass db | gzip -c | ncftpput -u login-p pass-c host /db.gz
mysqldump large tables to lock the table, and this is unacceptable. - Evalyn.West commented on July 9th 19 at 13:27
: --single-transaction=1 --lock-tables=false is not? In any case, you have what alternatives? - Robert commented on July 9th 19 at 13:30
For --single-transaction=1 --lock-tables=false did not know, thank you. - Evalyn.West commented on July 9th 19 at 13:33
July 9th 19 at 13:26
"Gentlemen, you beasts, gentlemen!" (C) "Cruel romance"
To pour somewhere in the realtime backup from the server database to another host is a perversion of the highest level! (...and on the verge of poverty)
Or if we do - will need to add a check that the backup is valid (supposedly to try after you create a deploy from backup database...)
A simple example: when you create a backup of the briefly lost network connection (and possibly multiple times... the magnitude of the disappearance of communication between hosts - from a few milliseconds to 1-3 seconds...). It is likely that the programme of recapitulare will not have time to "react" on such conflicts and on completion of the process will reveal that the backup is successfully created! Although such backup copy - just in the trash...
For the blood of generations of administrators issued a reasonable algorithm: creates a local backup copy and then poured already on the required host... at current prices for SATA-screws (a dozen in a bucket!) - it is wiser to buy and install the cheapest SATA the screw, than to engage in perversions, IMHO...
July 9th 19 at 13:28
Proveshivajut to your local computer port 3306/tcp via ssh from the server and treat your car to a local musculo, bakapit immediately to his car.
And you can detail how to do it?) - Evalyn.West commented on July 9th 19 at 13:31
: depends on what ssh client you are using.
Google "your ssh client port forward"
Basically it can use that putty, xshell what(you wrote that you have Windows).
But for normal ssh see man ssh and there you will see the key -L. - Robert commented on July 9th 19 at 13:34
July 9th 19 at 13:30
Take VDS in VScale for a short time, to put the nix on my virtual Windows, to increase the tariff plan (if you have a VDS)....
I have not VDS, the place can not increase; on the VScale, I can see the tariff plans, a maximum of 80GB, I need at least 85GB. - Evalyn.West commented on July 9th 19 at 13:33
: You can take 3 and make Ceph more space. - Robert commented on July 9th 19 at 13:36
What does it mean to take 3? - Evalyn.West commented on July 9th 19 at 13:39
: to rent 3 servers (in VScale is not a month to do so will not be expensive) to combine their storage space with Ceph. - Evalyn.West commented on July 9th 19 at 13:42

Find more questions by tags FTPWindowsDebianMySQL