Hello

2012-01-23 Thread Crow
I want to create MySQL localhost.
___
freebsd-questions@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "freebsd-questions-unsubscr...@freebsd.org"


Re: Dump/Restore to disk and tape

2002-12-10 Thread Oliver Crow



On Tue, 10 Dec 2002, Matthew D. Fuller wrote:

> On Mon, Dec 09, 2002 at 08:44:29PM -0800 I heard the voice of
> Oliver Crow, and lo! it spake thus:
> >
> > Of course this doesn't work because pax just creates the file
> > 'dump.0.2002-10-10'.
> >
> > Is there some way to move a dump file to a set of tapes, without having to
> > do the dump from the original filesystem?
>
> Have you tried symlinking dump.0.2002-10-10 to /dev/stdout, and then
> doing the | restore?  Kinda a twisted way of doing it, but it may work.

I tried that, but pax deletes the symlink and replaces it with the dump
file.  I also tried using the pax filename substitution facility, in the
hope that that would persuade it to open the stdout device:

% pax -r -f /dev/sa0 -s :.*:/dev/stdout:

Don't try this at home!  It deleted the /dev/stdout device entry.


I think though I *have* found a solution.

archive:
% gtar cM dump.*.gz

restore:
% gtar xMO dump.0.2002-10-10.gz | zcat | restore -if -


It's not ideal because it depends on a package that's not part of the
standard FreeBSD install.  It has to be gtar, to avoid the 2GB file size
limitation of tar. I also think it won't recover if part of a tape is
damaged, because it is storing compressed dump files.  The ideal solution
would be if dump had a feature to split a single existing dump file across
multiple volumes.  That way 'restore' would recover from read errors on
the tape, and only the affected files would be lost, instead of the
remainder of the archive.

Oliver




To Unsubscribe: send mail to [EMAIL PROTECTED]
with "unsubscribe freebsd-questions" in the body of the message



Dump/Restore to disk and tape

2002-12-09 Thread Oliver Crow


Question about use of dump/restore:

I do daily dumps of several FreeBSD machines over the network to a large
archive disk.  This disk has directories for different machines, with
several gzip'd dump files for each.  I have a tape drive on that machine,
and I'd like to copy some of the dump files to tape.

I started off using dd to copy the dump file to tape:
% dd if=dump.0.2002-10-10.gz of=/dev/sa0

But I don't think that dd handles multiple volumes if the dump file ends
up being larger than a single tape.  I could split the file first, but I'd
rather use a program that can automatically handle splitting a file across
several volumes.

I tried to use tar or cpio to copy the dump files to tape archives.  That
way the tape would have a tar archive of dump files.  Unfortunately both
of those programs seem to choke on files >2GB.  I tried using pax.  Pax is
fine with files >2GB, but there's another problem.  To retrieve the
contents of a dump file, I have to copy the entire thing to disk first.
This is awkward for large dump files because it's slow and I may not have
enough space for the entire file.

I can't find a way to extract the file to stdout, and pipe it directly to
restore. I'm thinking of something like:
% pax -r /dev/sa0 dump.0.2002-10-10 | restore -if -

Of course this doesn't work because pax just creates the file
'dump.0.2002-10-10'.

Is there some way to move a dump file to a set of tapes, without having to
do the dump from the original filesystem?

Thanks,
Oliver


To Unsubscribe: send mail to [EMAIL PROTECTED]
with "unsubscribe freebsd-questions" in the body of the message