468,769 Members | 2,263 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,769 developers. It's quick & easy.

[Q] Backing up a MySql Database

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.

Jul 20 '05 #1
2 1182

"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
Jul 20 '05 #2
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.
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Dave Moore | last post: by
reply views Thread by mdh | last post: by
1 post views Thread by rob.w | last post: by
12 posts views Thread by mistral | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.