I've tried using mysqldump, and it doesn't seem to be working on our
computer. A little more info on our setup is in order, I think.
We're running on Iserver, and have a virtual BSD machine. Most of the
binaries are in the 'true' machine's folders, and a few are in our
virtual machine's folders. I'm not sure if this is what's messing up
mysqldump, but when I tried to use it as the manual describes, it
refused to output anything but the helpfile.
-----Original Message-----
From: Joshua J. Kugler [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 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 table before it dumps, so there won't
be any
funny records. Or course, mysqldump could catch the database in the
middle
of a multi-table backup. But so can any live backup system.
j----- k-----
On Wednesday 29 August 2001 10:52, David Turner wrote:
> 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 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 recommended procedure for this?
--
Joshua Kugler, Information Services Director
Associated Students of the University of Alaska Fairbanks
[EMAIL PROTECTED], 907-474-7601
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
