Background: Solaris 10, MySQL 5.0.45.
I have changed something recently that is causing the error log file to be
created with mode 660. I would like for it it be mode 664. I admit that I
recently changed the my.cnf file and added a log-error line which did not
have the fully qualified path and cau
vent
---
-Original Message-
From: Hal Vaughan [mailto:[EMAIL PROTECTED]
Sent: Tuesday, 3 January 2006 7:54 AM
To: mysql@lists.mysql.com
Subject: File Permissions On Database Files
My
My MySQL databases are stored in a directory that is with the rest of my
project. I am using rsync to back up the entire project, including the
database files. I'd much rather do it this way than to create files with
mysqldump. Whenever MySQL creates a new database, the file is owned by the
At 10:17 11/01/2003 +0100, Dirkjan Ochtman wrote:
Hi,
server, I can DROP one of the tables, then I get the error again for the
other table, so then I restart the server again and I can DROP the last
table. The problem also persists on ALTERing TABLEs.
Please if possible for you send me a tes
tely
> > > after restarting the server, it worked, but then after a few minutes
> I
> > tried
> > > to ALTER another field in the table, and it had the same problem. So
> I
> > > restarted the server again, it went through, but the problem
> per
: Saturday, January 11, 2003 12:31 AM
Subject: Re: file permissions problem on ALTER TABLE
> Hmm, okay, but isn't the 3.23 supposed to be stable and thus more bugless
> than a gamma like 4.0.7?
>
> And also, I was wondering when 4 is going to be released as stable.
> Looking over
8-3
>
> - Original Message -
> From: "Dirkjan Ochtman" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, January 10, 2003 7:40 PM
> Subject: Bug: file permissions problem on ALTER TABLE
>
>
> > > Hi there,
> &g
<http://iConnect.de>
Heesestr. 6, 12169 Berlin (Germany)
Tel: +49 30 7970948-0 Fax: +49 30 7970948-3
- Original Message -
From: "Dirkjan Ochtman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 7:40 PM
Subject: Bug: file permissions
gain, it went through, but the problem persisted. I
> checked the file permissions, but everyone has full control to the files.
>
> The table now looks like this:
>
> CREATE TABLE postcodes (
> id mediumint(8) unsigned NOT NULL auto_increment,
> postcode char(6) NOT NULL default &
The manual says:
chown -R mysql.mysql /usr/local/mysql
You did not do that.
Do the same for MySQL's data directory.
Michael Sellers wrote:
>I'm very new to mysql. Just learning. I'm trying to correctly set up the
>permissions for the files under the mysql/ directory. I've included a
>lis
I'm very new to mysql. Just learning. I'm trying to correctly set up the
permissions for the files under the mysql/ directory. I've included a
list. I would appreciate it if some one could look over it and recommend
changes. Thank you.
Michael Sellers
ECTED]
Subject: File permissions
Hi All!
i tried the load_file after changing the File_priv in the user table of
mysql database for a particular user 'user1'...
insert into ecg_datafile values(1,1,load_file('/home/Venu/fr1w.jpg'));
ERROR 13: Can't get stat of '/home/
the mysql account under which the server runs does not have permission
to read
the file or its directory.
Venugopal Allavatam wrote:
> Hi All!
> i tried the load_file after changing the File_priv in the user table of
> mysql database for a particular user 'user1'...
>
> insert into ecg_datafi
Hi All!
i tried the load_file after changing the File_priv in the user table of
mysql database for a particular user 'user1'...
insert into ecg_datafile values(1,1,load_file('/home/Venu/fr1w.jpg'));
ERROR 13: Can't get stat of '/home/Venu/fr1w.jpg' (Errcode: 13)
i get the following error, can a
14 matches
Mail list logo
