If your database is large enough then any sort of hot backup
will lock the tables for too long. The method I use is to
use LVM to take a snapshot of the MySQL partition while
MySQL is stopped. All my attempts to snapshot a live MySQL
database resulted in inconsistent results...
The following is
less you tell
> it to.
>
> Thanks for everyone's help. I now have a working backup script.
>
> -Original Message-
> From: David Turner [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 29, 2001 1:00 PM
> To: Joshua J. Kugler
> Cc: David Turner; Matthew W
OTECTED]]
Sent: Wednesday, August 29, 2001 1:00 PM
To: Joshua J. Kugler
Cc: David Turner; Matthew Walker; MySQL Mailling List
Subject: Re: Hot Backups
Didn't read your last item before I fired my last message off. If
mysqldump locks the
table before it dumps then it is interupting servi
Matthew Walker ([EMAIL PROTECTED]) writes:
> What's the best way of doing a hot backup on a database? Our server is
> set up in such a way that it's not a simple matter to shut down
> apache/mysql and do the backup then. So, is it safe to just copy the
> mysql directories, or is there some recomm
On Wed, Aug 29, 2001 at 12:50:06PM -0600, Matthew Walker wrote:
>
> What's the best way of doing a hot backup on a database? Our server
> is set up in such a way that it's not a simple matter to shut down
> apache/mysql and do the backup then. So, is it safe to just copy the
> mysql directories, o
gust 29, 2001 11:52 AM
> To: David Turner; Matthew Walker
> Cc: MySQL Mailling List
> Subject: Re: Hot Backups
>
>
> I'm doing a mysqldump and then backing up the resulting text
> file. Works
> fine, doesn't interupt anything, and doesn't have any
> p
t 29, 2001 12:52 PM
To: David Turner; Matthew Walker
Cc: MySQL Mailling List
Subject: Re: Hot Backups
I'm doing a mysqldump and then backing up the resulting text file.
Works
fine, doesn't interupt anything, and doesn't have any problems with a
live
server. IIRC, mysqldump locks a
Didn't read your last item before I fired my last message off. If mysqldump locks the
table before it dumps then it is interupting service. If I have a high number of
transactions they're blocked until the lock is released.
Dave
On Wed, Aug 29, 2001 at 10:52:26AM -0800, Joshua J. Kugler wrote:
>
Any problems with data inconsistencies?
Dave
On Wed, Aug 29, 2001 at 10:52:26AM -0800, Joshua J. Kugler wrote:
> I'm doing a mysqldump and then backing up the resulting text file. Works
> fine, doesn't interupt anything, and doesn't have any problems with a live
> server. IIRC, mysqldump lock
I'm doing a mysqldump and then backing up the resulting text file. Works
fine, doesn't interupt anything, and doesn't have any problems with a live
server. IIRC, mysqldump locks a table before it dumps, so there won't be any
funny records. Or course, mysqldump could catch the database in the
The way I am planning on doing it is setting up another server that I replicated to
and backing that server up. I would like to hear how other people are backing up
servers
without interupting service.
Dave
On Wed, Aug 29, 2001 at 12:50:06PM -0600, Matthew Walker wrote:
> What's the best way of
11 matches
Mail list logo
