I am willing to pay for the following. And I find it unreal that a back up solution does not already exist.
Server: Linux
Extras: contains a backup storage drive
Problem: An automatic backup solution.
Problem: Doing mysqlhotcopy by hand is not fun. Running it as a perl script, or php exec cron would be better. And have done this to run once a week.
Problem 2: Binary logging, would like to have them flushed nightly. New file for each day..I have done this
Problem 3: Making the mysql hot copy sync perfectly with the binary logs so the hotcopy and the logs are a perfect match
needs:
a sunday night backup of the database, with a seven day group of bin logs that come after it. Then a sunday back up with 7 more bin logs.
This gives me two weeks back up with ability to go forward/backward in time pretty easy..heck, even a one week back up would be nice.
Now, why is there not a backup system like this out there?
Reason for this system:
Up to the minute rebuild incase of errors. Two week back up incase of hackers or errors not detected earlier enough, allows a 1/2 month worth of data to go back and forth.
A hacker could wipe out your data or csmic rays even. I want to be able to rebuild easily from the last backup to the minute/sec it was deleted, detroyed, hacked, whatever.
Problem 4: manually doing the mysqlbinlog. Is there not a batch function that can get file 001 to 007 and run them as one ?
There has to be a way to do this.....
Willing to pay
Help
bob@bobhoffman.com