From owner-freebsd-questions  Thu Feb 14  6:25:31 2002
Delivered-To: freebsd-questions@freebsd.org
Received: from web13403.mail.yahoo.com (web13403.mail.yahoo.com [216.136.175.61])
	by hub.freebsd.org (Postfix) with SMTP id 87DCC37B416
	for <freebsd-questions@freebsd.org>; Thu, 14 Feb 2002 06:25:24 -0800 (PST)
Message-ID: <20020214142524.75235.qmail@web13403.mail.yahoo.com>
Received: from [4.18.79.251] by web13403.mail.yahoo.com via HTTP; Thu, 14 Feb 2002 06:25:24 PST
Date: Thu, 14 Feb 2002 06:25:24 -0800 (PST)
From: Andrew Gould <andrewgould@yahoo.com>
Subject: Re: 4.5-release: Weird problem with mysqldump and permissions(?)
To: James Green <james@stealthnet.co.uk>,
	freebsd-questions@freebsd.org
In-Reply-To: <IGEPIJPNHPMGCANGLCBHOEKFCBAA.james@stealthnet.co.uk>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Sender: owner-freebsd-questions@FreeBSD.ORG
Precedence: bulk
List-ID: <freebsd-questions.FreeBSD.ORG>
List-Archive: <http://docs.freebsd.org/mail/> (Web Archive)
List-Help: <mailto:majordomo@FreeBSD.ORG?subject=help> (List Instructions)
List-Subscribe: <mailto:majordomo@FreeBSD.ORG?subject=subscribe%20freebsd-questions>
List-Unsubscribe: <mailto:majordomo@FreeBSD.ORG?subject=unsubscribe%20freebsd-questions>
X-Loop: FreeBSD.ORG

--- James Green <james@stealthnet.co.uk> wrote:
> Hi all,
> 
> We're trying to back up our database using mysqldump
> in various formats. We
> have a shell script to do this and it works
> perfectly on one freebsd machine
> but not on another.
> 
> Here is the error:
> 
> r2b% ./dbdump.sh
> /usr/local/bin/mysqldump: Got error: 1: Can't
> create/write to file
>
'/usr/local/www/xx.xx.xx.xxx/dbdumps/2002-02-14/categories.txt'
> (Errcode:
> 13) when executing 'SELECT INTO OUTFILE'
> tar: Removing leading / from absolute path names in
> the archive.
> r2b% touch
>
/usr/local/www/xx.xx.xx.xxx/dbdumps/2002-02-14/categories.txt
> r2b%
> 
> As you can see there's no problem with me
> creating/writing the file.
> categories.ext was created fine, but the .txt file
> doesn't like being done.
> 
> r2b% df -h
> Filesystem    Size   Used  Avail Capacity  Mounted
> on
> /dev/ad0s1a   126M    31M    85M    27%    /
> /dev/ad0s1f   252M   8.0K   232M     0%    /tmp
> /dev/ad0s1g    25G   1.1G    22G     5%    /usr
> /dev/ad0s1e   252M   4.8M   227M     2%    /var
> procfs        4.0K   4.0K     0B   100%    /proc
> 
> So no problem with disk space. MySQL uses /var/tmp
> for temporary space, and
> the permissions there are fine.
> 
> Other MySQL dumps of the same tables work fine (in
> other formats) but not
> this one (it's the one that dumps a file for table
> structure and another for
> table data).
> 
> I'm at a loss to explain it. Any ideas out there
> would be appreciated :).
> 
> Thanks,
> 
> --
> James Green
> Developer
> Stealthnet.co.uk

Please provide the contents of dbdump.sh.

Andrew Gould

__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com

To Unsubscribe: send mail to majordomo@FreeBSD.org
with "unsubscribe freebsd-questions" in the body of the message