[Q] Backing up a MySql Database

[Eric]

I've taken a look at mysqlhotcopy and mysqldump but neither seem to do
what I need them to do which is to backup only the data which has
changed since the last backup.

Is there a way to do this?

Of course, being able to recover the database from these delta backups
is important.

[Mike Chirico]

"Eric" <eg******@verizon.net> wrote in message
news:1gffnga.1tss5a61fhouzeN%eg******@verizon.net. ..

I've taken a look at mysqlhotcopy and mysqldump but neither seem to do
what I need them to do which is to backup only the data which has
changed since the last backup.

Is there a way to do this?

Of course, being able to recover the database from these delta backups
is important.

Eric:

Binary log files might provide some help. They do list all of the sql
commands, the time of the commands, and the thread. After the commands are
listed, it may be possible to "selectively" get changes for say just one
user. That requires both the binary log file and text log files are used.
The text log file shows the actual user name, whereas the binary log file
has a lot of other info.

Reference (TIP 30, TIP 24, TIP 25):
http://prdownloads.sourceforge.net/s...l.txt?download

I hope it helps. Yes, I haven't found a real clean solution either.

Regards,

Mike Chirico

[Eric]

Mike Chirico <mc******@comcast.net> wrote:

Binary log files might provide some help. They do list all of the sql
commands, the time of the commands, and the thread. After the commands are
listed, it may be possible to "selectively" get changes for say just one
user. That requires both the binary log file and text log files are used.
The text log file shows the actual user name, whereas the binary log file
has a lot of other info.

Reference (TIP 30, TIP 24, TIP 25):
http://prdownloads.sourceforge.net/s...l.txt?download

I hope it helps. Yes, I haven't found a real clean solution either.

Huh. I'm kinda surprised there isn't a clean solution as this seems to
be an obviously useful feature.

In any case, thanks for the info.