gt;
>> <mailto:rja...@yahoo-inc.com>>**> wrote:
>>
>> SELinux ?
>>
>> > -Original Message-
>> > From: Lixun Peng [mailto:pengli...@gmail.com
>>
The reason this is significant is because we are speaking about INFILE
use. The server processes infile commands assuming the file is already
stored on the server. LOCAL INFILE tells mysql that file is local to the
mysql client and must be moved to the server before processing. I suspect
that thi
<mailto:pengli...@gmail.com <mailto:pengli...@gmail.com>>]
> Sent: Tuesday, October 16, 2012 9:03 PM
> To: kalin
> Cc: Michael Dykman; mysql@lists.mysql.com
<mailto:mysql@li
;mailto:rja...@yahoo-inc.com>> wrote:
>>
>> SELinux ?
>>
>> > -Original Message-
>> > From: Lixun Peng [mailto:pengli...@gmail.com
>> <mailto:pengli...@gmail.com>]
>> > Sent: Tuesday, October 16, 2012
alin
> Cc: Michael Dykman; mysql@lists.mysql.com
<mailto:mysql@lists.mysql.com>
> Subject: Re: error 13
>
> Hi,
>
> you can switch to mysql user "su - mysql", and then stat this
file.
> if you can&
gt;
>> > -Original Message-
>> > From: Lixun Peng [mailto:pengli...@gmail.com]
>> > Sent: Tuesday, October 16, 2012 9:03 PM
>> > To: kalin
>> > Cc: Michael Dykman; mysql@lists.mysql.com
>> > Subject: Re: error 13
>> >
>> >
> Cc: Michael Dykman; mysql@lists.mysql.com
> > Subject: Re: error 13
> >
> > Hi,
> >
> > you can switch to mysql user "su - mysql", and then stat this file.
> > if you can't access, mysql user have not permissions.
> >
> > On Wed, O
SELinux ?
> -Original Message-
> From: Lixun Peng [mailto:pengli...@gmail.com]
> Sent: Tuesday, October 16, 2012 9:03 PM
> To: kalin
> Cc: Michael Dykman; mysql@lists.mysql.com
> Subject: Re: error 13
>
> Hi,
>
> you can switch to mysql user "su - my
Hi,
you can switch to mysql user "su - mysql", and then stat this file.
if you can't access, mysql user have not permissions.
On Wed, Oct 17, 2012 at 11:49 AM, kalin wrote:
>
>
>
> On 10/16/12 10:49 PM, Michael Dykman wrote:
>
>> is your mysql client on the same host as the mysql server? if not
On 10/16/12 10:49 PM, Michael Dykman wrote:
is your mysql client on the same host as the mysql server? if not, google
the docs for 'local infile'
yes. my laptop.
On 2012-10-16 10:45 PM, "Lixun Peng" wrote:
Hi,
What's the dir permissions?
For example, if we have a file in /a/b/file,
when i do:
mysql> load data infile '/path/to/file' etc...
i get:
ERROR 13 (HY000): Can't get stat of '/path/to/file' (Errcode: 13)
ls -al /path/to/file
lists the file...
so why do i get errcode 13?!
i'm on os x.
thanks.
is your mysql client on the same host as the mysql server? if not, google
the docs for 'local infile'
On 2012-10-16 10:45 PM, "Lixun Peng" wrote:
Hi,
What's the dir permissions?
For example, if we have a file in /a/b/file, dir a is 644, even though file
is 777, we can't access file, too.
On
s root on the command line cleint. trying to load data infile
> '/path/to/file'
>
> file is owned by mysql and it has 777 permissions. the directory where the
> file is is also owned by mysql.
>
> when i do:
> mysql> load data infile '/path/to/file' e
ile '/path/to/file' etc...
i get:
ERROR 13 (HY000): Can't get stat of '/path/to/file' (Errcode: 13)
ls -al /path/to/file
lists the file...
so why do i get errcode 13?!
i'm on os x.
thanks...
--
MySQL General Mailing List
For list archives: http://lists.mysq
'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> load data infile '/var/lib/mysql/e5publishers.txt'
-> into table e5publishers
-> fields terminated by ' ';
ERROR 13 (HY000): Can't get stat of
Kristen G. Thorson wrote:
-Original Message-
From: Artem Kuchin [mailto:[EMAIL PROTECTED]
Sent: Friday, November 02, 2007 9:23 AM
To: Baron Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: sporadic error 13 on windows
DBD::mysql::st execute failed: Can't create/write to file
'
-Original Message-
From: Artem Kuchin [mailto:[EMAIL PROTECTED]
Sent: Friday, November 02, 2007 9:23 AM
To: Baron Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: sporadic error 13 on windows
DBD::mysql::st execute failed: Can't create/write to file '#sql_948_0.MYD'
(
Baron Schwartz wrote:
What do you get from the following:
mysql> show variables like '%tmp%';
1) if i set
tmpdir=C:/temp
it shows:
mysql> show variables like '%tmp%';
+---+---+
| Variable_name | Value |
+---+---+
| max_tmp_tables| 32
What do you get from the following:
mysql> show variables like '%tmp%';
Artem Kuchin wrote:
anyone any idea on this ?
On 10/31/07, Artem Kuchin <[EMAIL PROTECTED]> wrote:
I am running
Server version: 5.0.45-community-nt MySQL Community Edition (GPL)
on WIndows 2003 R2 Service Pack 2 Standar
anyone any idea on this ?
On 10/31/07, Artem Kuchin <[EMAIL PROTECTED]> wrote:
I am running
Server version: 5.0.45-community-nt MySQL Community Edition (GPL)
on WIndows 2003 R2 Service Pack 2 Standard Edition
I have a database dig perl script with basically does a lot of
SELECT [somefield] as
Just a thought, (I'm certainly no wondows guy) but perhaps your
setting for the TMP directory would be respected if you used the DOS
format path with the backslash..
tmpdir=C:\temp
vs.
tmpdir=C:/temp
tried it, still:
DBD::mysql::st execute failed: Can't create/write to file '#sql_152c_0.MYD'
I am running
Server version: 5.0.45-community-nt MySQL Community Edition (GPL)
on WIndows 2003 R2 Service Pack 2 Standard Edition
I have a database dig perl script with basically does a lot of
SELECT [somefield] as tt FROM table;
When i run it i get:
DBD::mysql::st execute failed: Can't crea
mysql> LOAD DATA INFILE '/home/thufir/abc.txt' INTO TABLE delta.abc;
ERROR 13 (HY000): Can't get stat of '/home/thufir/abc.txt' (Errcode: 13)
'13' means permission denied.
That is - mysql (which is running as user 'mysql' most likely), can
|
> +-+
> | abc |
> +-+
> 1 row in set (0.00 sec)
>
> mysql> describe abc;
> +---+--+--+-+-+---+
> | Field | Type | Null | Key | Default | Extra |
> +---+--+--+-+-----+-
---+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| a | text | NO | | | |
| b | text | NO | | | |
| c | text | NO | | | |
+---+--+------+-+-+---+
3 rows in se
tor? is
it really so unstable on Windows after some time?
--
Yves Goergen
[EMAIL PROTECTED]
Please don't CC me (causes double mails)
- Original Message -
From: "William Fong" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 19, 2003 8:24 PM
S
Check this out:
http://www.mysql.com/doc/en/Repair.html
-will
- Original Message -
From: "Yves Goergen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, November 19, 2003 11:12 AM
Subject: Re: error 13
> I just received another error message I d
I just received another error message I don't know what to do with:
Got error 127 from table handler
I tried to alter a table's structure. A restart of MySQL did help. A table
CHECK showed no errors with that table.
--
Yves Goergen
[EMAIL PROTECTED]
Please don't CC me (causes double mails)
Hi there,
I'm running MySQL 4.0.16-nt (previously 3.23.5x, same system, same problem)
on Windows 2000 Pro SP3 and almost constantly run against the following
error (or similar) when I try to alter something about the structure of a
table (MyISAM database):
Error on rename of '.\BlackBoard\uni_
I posted a query on this a couple of days ago, but have tried an alternative
tack.
Using MyCC to add a field to a table, I get an error
[localhost] ERROR 7: Error on rename of '.\rocktest\companies.MYI' to
'.\rocktest\#sql2-15c-15.MYI' (Errcode: 13)
But If I use mysql from the command line
mys
(). But each time
I run the Macro I get an error message.
In the Visual Basic window the following part of the code type is
highlighted in yellow it is part of the section Check Primary property.
For Each fld In idx.Fields
Type mismatch (Error 13)
'Check Primary property
10 January 2002 8:27 a.m.
> To: 'P.Agenbag'; mysql
> Subject: RE: Error 13
>
>
> Hi
>
> Error 13 is from the OS - nothing to do with locks or whatever.
>
> However, when you add a new field (or change the table structure
> in (nearly)
> any way), mysqld
Your new best friend:
http://www.phpwizard.net/projects/phpMyAdmin/
Original Message Follows
From: "P.Agenbag" <[EMAIL PROTECTED]>
To: mysql <[EMAIL PROTECTED]>
Subject: Error 13
Date: Wed, 09 Jan 2002 19:13:51 +0200
Hi
I have a table that I want to add a new fie
Hi
Error 13 is from the OS - nothing to do with locks or whatever.
However, when you add a new field (or change the table structure in (nearly)
any way), mysqld will create a temporary table in the database directory -
are you sure that the permissions on the directory are correct?
Remember
Hi
I have a table that I want to add a new field to while running on the
server, however, when I try to add a new field, it comes up with the
error13 message, saying it doesn't have permission, yet the files and
folder are all chmod 777. Can it be due to the fact that there is a
permanent conn
run the perror app that should of come with your distribution
perror 13
Terry Shipclark wrote:
>
> What does this error mean?? Any help would be appreciated
>
>
>
> Terry Shipclark
> Technical Support Representitave/Cati Operator
> [EMAIL PROTECTED]
> tel. 416-445-9800 ext 2093
> www.bbm.ca
What does this error mean?? Any help would be appreciated
Terry Shipclark
Technical Support Representitave/Cati Operator
[EMAIL PROTECTED]
tel. 416-445-9800 ext 2093
www.bbm.ca
-
Before posting, please check:
http
At 20:45 26/04/01 -0700, Brent and Maria wrote:
Hi,
I guess that your problem is the permission of the user that
you made the login. Take a look to permission properties
in the \mysql\data directory.
Regards,
Miguel
>Hello List,
> I have recently installed mysql 3.23.33 on my windows 200
Hello List,
I have recently installed mysql 3.23.33 on my windows 2000 machine. I
don't see anything in the documentation that I need to do to my machine for
setup (after the installation). I can run mysql fine, but it seems to be
only able to read. I want to create a new database.
39 matches
Mail list logo