By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,636 Members | 1,814 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,636 IT Pros & Developers. It's quick & easy.

[Q] Backing up a MySql Database

P: n/a
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
Share this Question
Share on Google+
2 Replies


P: n/a

"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

P: n/a
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.