I have a very large mysql database - primarily as photos are being stored as blob. It takes too long to backup to my local PC. How can I make a backup that is not on the hosting server?
For large database use Incremental back stretagy
Second thing keeping photos in database will suffur you a lot after long time
in database size as well as performance wise
so keep photos on the disk and specify link of location of photos in database only.