@scottalanmiller said in Turn server into backup storage for remote servers?:
We typically are backing up databases, so full normally.
Just a side note but one way to make partial backups from databases is to have a "modified date/time" column for large tables.
Then you can do partial backups by looking at the "modified" timestamp and including all rows that has been modified since the last backup.
select * from tableX where modified_datetime>last_backup;
This can be done fully application independent if the database have triggers. The trigger will automatically update the "modified date/time" when changes are made and the application has no clue.
This is an example how to create a trigger that saves when a row is updated:
create trigger update_modified
before update on table tableX
for each row
set new.modified_datetime=now();
This obviously only makes sense when backups are getting big enough to warrant the extra work.
