Tim, it's a gnarly problem that most DBAs struggle with in some form or
another, whether using MySQL or another database package.
If you're using only MyISAM tables, MySQL's free, included 'mysqlhotcopy'
script might work for you, as it's generally a bit faster than mysqldump in
my experience. If you're on InnoDB, there is a commercial product that
offers live backups ('InnoBackup' I think). No experience with that myself.
You could also look at setting up a second database server replicating from
the first, and run your backups off the second server.
There's also the subject of "consistent snapshot" vs. a simple serial backup
of your tables, which can be a tricky thing to work out satisfactorily
without complete database locks.
Dan
On 5/22/07, tim h <[EMAIL PROTECTED]> wrote:
is there a safe way to dump/backup a live database without disrupting
service? when i run mysqldump the whole server comes to a crawl and
queries
start taking 60+ seconds to complete.
is there a way to make mysqldump run at low priority?
worst case scenario is i miss the queries that took place during the
backup
right?
Tim
