I am learning the DBA ropes on a MySQL 4.0.14 database. I am working on
a backup strategy and I have a few questions. But first, a bit about the
database: we are collecting "messages" from a customer, storing them in
a table, then pushing the data to a master database. The messages are
inserts into the table. We get roughly 9million inserts a week. Nothing
else is done to the database.
What I want to do is this:
1. Do a full snapshot of the tables and data once a week (I know how to
do this with mysqldump).
2. Do a daily incremental backup. I can do this two ways:
A. Do a mysqldump of all the data for that day
B. Use the update-log (or binary-log) and back that up.
Which is the best way? I am looking for small size and ease of
restoration.
I am leaning towards the update-log, since this database has so many
record additions. Any ideas?
Ben Ricker
Wellinx, Inc.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
