@lists.mysql.com
mailto:mysql@lists.mysql.com
mailto:mysql@lists.mysql.com
mailto:mysql@lists.mysql.com**
Subject: Re: error 13
Hi,
you can switch to mysql user su
16, 2012 9:03 PM
To: kalin
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
, October 16, 2012 9:03 PM
To: kalin
Cc: Michael Dykman; mysql@lists.mysql.com
mailto:mysql@lists.mysql.com
mailto:mysql@lists.mysql.com
mailto:mysql@lists.mysql.com
Subject: Re: error 13
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
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 - mysql, and then stat this file.
if you can't
@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, Oct 17, 2012 at 11:49 AM, kalin ka...@el.net wrote:
On 10/16/12 10:49 PM, Michael Dykman wrote:
is your
-
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 - mysql, and then stat this file.
if you can't access, mysql user have
@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, Oct 17, 2012 at 11:49 AM, kalin ka...@el.net
...
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.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
. 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' etc...
i get:
ERROR 13 (HY000): Can't get stat of '/path/to/file' (Errcode: 13)
ls -al
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 pengli...@gmail.com 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
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...
--
MySQL General Mailing List
For list archives
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 pengli...@gmail.com wrote:
Hi,
What's the dir permissions?
For example, if we have a
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 ka...@el.net wrote:
On 10/16/12 10:49 PM, Michael Dykman wrote:
is your mysql client on the same host as the mysql server? if
'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 '/var/lib/mysql/e5publishers.txt'
(Errcode: 13)
mysql show grants
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
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
'#sql_948_0
-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'
(Errcode: 13
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 Standard
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
| NO | | | |
| c | text | NO | | | |
+---+--+--+-+-+---+
3 rows in set (0.01 sec)
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)
mysql
| NO | | | |
| c | text | NO | | | |
+---+--+--+-+-+---+
3 rows in set (0.01 sec)
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)
mysql
mysql quit
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't
read the /path/to/abc.txt file.
Place the file
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
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 don't know what to do
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
Subject: Re: error 13
Check this out:
http
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
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
(). 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
k = k
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
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
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 field to while running
.
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 will create a temporary table in the database directory -
are you sure
What does this error mean?? Any help would be appreciated
!--database mysql query relational--
Terry Shipclark
Technical Support Representitave/Cati Operator
[EMAIL PROTECTED]
tel. 416-445-9800 ext 2093
www.bbm.ca
-
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
!--database mysql query relational--
Terry Shipclark
Technical Support Representitave/Cati Operator
[EMAIL PROTECTED]
tel.
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 2000
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