Speeding up

[Mark Buckland]

Hi there,

I'm fishing for some tips on how to speed up the processing of copy our DB to another location.

The current process (which happens every 24 hours) is:

1) Use mysqldump to dump the whole database onto a separate server (10 mins)

2) Insert the new dump file into the DB (1 hour)

3) Anonymise the field 'client' in the DB (1 hour)

For speed ups, we were thinking one way was to just get a dump of the last 24 hours of the original DB. How would we go about doing this?

Thanks!

- Mark.