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?
eleanore.McCullough answered on 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...
Deshaun.Skil answered on 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.
Weston98 answered on 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)....