I followed the manpage for mysqlimport:
thufir@dur:~$
thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id INT, n VARCHAR(30))' test
ERROR 1045 (28000): Access denied for user 'thufir'@'localhost' (using
password: NO)
thufir@dur:~$
thufir@dur:~$
thufir@dur:~$ mysql -e 'CREATE TABLE imptest(id
have access to /tmp?...
ERROR 29 (HY000): File '/tmp/make_year_model.csv' not found (Errcode: 13)
then file not found is bullshit
these days computers can distinguish between
not exist and no permissions and should reflect
that in the messages they give to humans
signature.asc
Description
I think it's apparmor:
thufir@dur:/tmp$
thufir@dur:/tmp$ nl /etc/apparmor.d/usr.sbin.mysqld
1 # vim:syntax=apparmor
2 # Last Modified: Tue Jun 19 17:37:30 2007
3 #include tunables/global
4 /usr/sbin/mysqld {
5#include abstractions/base
6#include
/make_year_model.csv' not found
(Errcode: 13)
mysql
mysql quit
Bye
thufir@dur:~$
thufir@dur:~$ cat /home/thufir/make_year_model.csv
make1,model1,2012,604,buy now
make2,model2,2013,780,need to sell
make3,model3,2001,780,cheap
thufir@dur:~$
thanks,
Thufir
vehicles.vehicles FIELDS TERMINATED BY ',' LINES TERMINATED BY
'\n';
ERROR 29 (HY000): File '/home/thufir/make_year_model.csv' not found
(Errcode: 13)
mysql
mysql quit
Bye
thufir@dur:~$
thufir@dur:~$ cat /home/thufir/make_year_model.csv
make1,model1,2012,604,buy
INFILE '/home/thufir/make_year_model.csv' INTO
TABLE vehicles.vehicles FIELDS TERMINATED BY ',' LINES TERMINATED BY
'\n';
ERROR 29 (HY000): File '/home/thufir/make_year_model.csv' not found
(Errcode: 13)
mysql
mysql quit
Bye
thufir@dur:~$
thufir@dur:~$ cat /home
. Type '\c' to clear the current input
statement.
mysql
mysql LOAD DATA INFILE '/home/thufir/make_year_model.csv' INTO
TABLE vehicles.vehicles FIELDS TERMINATED BY ',' LINES TERMINATED BY
'\n';
ERROR 29 (HY000): File '/home/thufir/make_year_model.csv' not found
(Errcode
.
mysql
mysql LOAD DATA INFILE '/home/thufir/make_year_model.csv' INTO
TABLE vehicles.vehicles FIELDS TERMINATED BY ',' LINES TERMINATED BY
'\n';
ERROR 29 (HY000): File '/home/thufir/make_year_model.csv' not found
(Errcode: 13)
mysql
mysql quit
Bye
thufir@dur:~$
thufir
TERMINATED BY ',' LINES TERMINATED BY '\n';
ERROR 29 (HY000): File '/tmp/make_year_model.csv' not found (Errcode: 13)
mysql
mysql quit
Bye
thufir@dur:/tmp$
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
-hgenome-mysql.cse.ucsc.edu mm9 -A
mysql select geneName as symbol, name as refSeq, chrom, strand,
txStart, txEnd from refFlat group by refSeq having count(*)=1;
ERROR 1 (HY000): Can't create/write to file
'/var/lib/mysql/#sql_9e1_0.MYI' (Errcode: 13)
Errcode is what mySQL writes for an errno
On Tue, Jan 18, 2011 at 6:24 AM, sushant chawla sushantchawla2...@gmail.com
wrote:
Make sure the following things:
- /tmp folder is having 1777 permissions
- mysql folder is having the ownership from which it is running. Refer
/etc/my.cnf
- Make sure you have space on your MySQL
select geneName as symbol, name as refSeq, chrom, strand,
txStart, txEnd from refFlat group by refSeq having count(*)=1;
ERROR 1 (HY000): Can't create/write to file
'/var/lib/mysql/#sql_9e1_0.MYI' (Errcode: 13)
--
Regards,
Peng
--
MySQL General Mailing List
For list archives: http
having count(*)=1;
ERROR 1 (HY000): Can't create/write to file
'/var/lib/mysql/#sql_9e1_0.MYI' (Errcode: 13)
--
Regards,
Peng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=yogeshk...@gmail.com
, txEnd from refFlat group by refSeq having count(*)=1;
ERROR 1 (HY000): Can't create/write to file
'/var/lib/mysql/#sql_9e1_0.MYI' (Errcode: 13)
--
Regards,
Peng
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http
'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
So I am trying to use mysqldump --tab for the first time. I am running
into the same problem everybody does on their first try --- Errcode: 13. I
have set the permissions on the target directory to be completely liberal
--- anybody can do anything with it --- and I still get Errcode: 13. I
Mike Spreitzer wrote:
So I am trying to use mysqldump --tab for the first time. I am running
into the same problem everybody does on their first try --- Errcode: 13. I
have set the permissions on the target directory to be completely liberal
--- anybody can do anything with it --- and I still
'
(Errcode: 13) when executing 'SELECT INTO OUTFILE'
[EMAIL PROTECTED] /]# ls -ld /dump1
drwxrwxrwx 2 mysql mysql 4096 Feb 22 19:11 /dump1
[EMAIL PROTECTED] /]# ls -l /dump1
total 16
-rw-r--r-- 1 mysql mysql 29 Feb 22 18:38 foo.bar
-rw-r--r-- 1 root root 742 Feb 22 19:11 red1_p2.sql
[EMAIL
what happens when you delete the files that are already in there? Looks
like you're dumping to a file owned by root.
Jed
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to file '/dump1/red1_p2.txt'
(Errcode: 13) when executing 'SELECT INTO OUTFILE'
[EMAIL PROTECTED] /]# ls -l dump1
total 8
-rw-r--r-- 1 root root 742 Feb 22 20:46 red1_p2.sql
[EMAIL PROTECTED] /]# ps axlw | grep mysqld
0 0 8494 1 25 0 3408 944 wait Spts/5 0:00 /bin/sh
/usr
:
mysqldump: Got error: 1: Can't create/write
to file '/dump1/red1_p2.txt' (Errcode: 13) when executing 'SELECT INTO
OUTFILE'
I'm reading thru http://dev.mysql.com/doc/refman/5.0/en/select.html and it says
that it will not write to an already existing file (so you deleted the old files
MySql - server version: 4.1.7
OS - RedHat Linux AS 4
mysql use Music;
mysql SELECT * INTO OUTFILE '/home/shaine/Music.csv' FROM Music_Details;
ERROR 1 (HY000): Can't create/write to file '/home/shaine/Music_Details.csv'
(Errcode: 13)
I faced a problem as mentioned above. really got stucked
Hi Shain,
Shain Lee wrote:
ERROR 1 (HY000): Can't create/write to file '/home/shaine/Music_Details.csv'
(Errcode: 13)
I faced a problem as mentioned above. really got stucked. how can i solve that
problem ? is it a bug ?
Error 13 is Permission Denied. The MySQL daemon cannot write to your
create/write to file '/home/shaine/Music_Details.csv'
(Errcode: 13)
I faced a problem as mentioned above. really got stucked. how can i solve
that problem ? is it a bug ?
Error 13 is Permission Denied. The MySQL daemon cannot write to your
home directory. Try using /tmp instead or some
mysql@lists.mysql.com
bcc:
Subject:Re: mysql data into CSV file. / (Errcode: 13)
Thank you , that is working with /tmp/ directory. actually what is the
issue behind writing that files into user defined folder , like
/home/test/ ?
have you find any solution for that ?
Thank
/mnt/FAT/mysqldata/localhost.lower-test
/usr/libexec/mysqld: Can't change dir to '/mnt/FAT/mysqldata/'
(Errcode: 13)
060421 8:43:11 [ERROR] Aborting
I'm guessing that since mysqld_safe runs as user mysql, maybe mysqld
runs as a different user?
How would I find that out?
I will keep
test file
/mnt/FAT/mysqldata/localhost.lower-test
/usr/libexec/mysqld: Can't change dir to '/mnt/FAT/mysqldata/'
(Errcode: 13)
060420 18:16:03 [ERROR] Aborting
However, I can start mysqld using: mysqld_safe, so I know it's possible.
Any suggestions? Thanks in advance.
Did you check FAT
/mysqldata/localhost.lower-test
/usr/libexec/mysqld: Can't change dir to '/mnt/FAT/mysqldata/'
(Errcode: 13)
060421 8:43:11 [ERROR] Aborting
I'm guessing that since mysqld_safe runs as user mysql, maybe mysqld
runs as a different user?
How would I find that out?
I will keep reading the manual
/mnt/FAT/mysqldata/localhost.lower-test
/usr/libexec/mysqld: Can't change dir to '/mnt/FAT/mysqldata/'
(Errcode: 13)
060420 18:16:03 [ERROR] Aborting
However, I can start mysqld using: mysqld_safe, so I know it's possible.
Any suggestions? Thanks in advance.
--
MySQL General Mailing List
For list
: 13)
After installing MySQL 5.0.2 on MDK10.0 mysqld doesn't start with error:
Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)
InnoDB, and mysqld in general, must be able to create temporary files.
http://dev.mysql.com/doc/mysql/en/Temporary_files.html
MySQL uses
tables
http://www.innodb.com/order.php
- Original Message -
From: Alejandro D. Burne [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Monday, December 06, 2004 2:40 PM
Subject: Re: Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode:
13)
Heikki I do it, in my.cnf
After installing MySQL 5.0.2 on MDK10.0 mysqld doesn't start with error:
Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)
I think it's a problem with innodb, if I add skip-innodb on my.cnf
mysqld starts up:
041203 14:04:01 mysqld started
041203 14:04:01 [Warning] Asked for 196608
Alejandro,
- Original Message -
From: Alejandro D. Burne [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Friday, December 03, 2004 7:20 PM
Subject: Bug? Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)
After installing MySQL 5.0.2 on MDK10.0 mysqld doesn't
I can't figure the solution:
#mysql -p -u Me sampdb create_president.sql
#Enter password:
ERROR 1 at line 5; Can't create/write to file './sampdb/president.frm'
(Errcode:13)
Please help.
-
Before posting, please check
At 11:36 -0700 3/10/03, Mark Berkwitt wrote:
I can't figure the solution:
#mysql -p -u Me sampdb create_president.sql
#Enter password:
ERROR 1 at line 5; Can't create/write to file './sampdb/president.frm'
(Errcode:13)
Please help.
% perror 1 13
Error code 1: Operation not permitted
Error
Dhanashri,
ALTER TABLE `timesheet` ADD `phase_desc` VARCHAR( 50 )
Error on rename of '.\etime\timesheet.MYI' to
'.\etime\#sql2-64c-19.MYI'
(Errcode: 13)
I had the same kind of problem with ALTER TABLE and MySQL 4.0.5 under
Win2K. Errorcode 13 means it's a permission problem. I never solved
Anybody have an idea about the following error (Errcode: 13)? I am simply
trying to add one more field in the table timesheet.
My phpMySQL version is 3.23.55-nt
Thanks.
-Dhanashri Peramanu
||
| AUSCALLERID | tinyint(4) | | | 0 ||
containing 481484 records,
mysql yields
mysql CREATE INDEX INDX_ANSCHLUSS ON ANSCHLUSS(TELEFON, REGION, LAND,
NETZ);
ERROR 1: Can't create/write to file '/home/data/mysql/tmp/STabnagj'
(Errcode
||
| AUSCALLERID | tinyint(4) | | | 0 ||
containing 481484 records,
mysql yields
mysql CREATE INDEX INDX_ANSCHLUSS ON ANSCHLUSS(TELEFON, REGION, LAND,
NETZ);
ERROR 1: Can't create/write to file '/home/data/mysql/tmp/STabnagj'
(Errcode: 13)
Stephan
records,
mysql yields
mysql CREATE INDEX INDX_ANSCHLUSS ON ANSCHLUSS(TELEFON, REGION, LAND,
NETZ);
ERROR 1: Can't create/write to file '/home/data/mysql/tmp/STabnagj'
(Errcode: 13)
Stephan,
tsp@host:~ perror 13
Error code 13: Permission denied
It must have to do with permissions
||
containing 481484 records,
mysql yields
mysql CREATE INDEX INDX_ANSCHLUSS ON ANSCHLUSS(TELEFON, REGION, LAND,
NETZ);
ERROR 1: Can't create/write to file '/home/data/mysql/tmp/STabnagj'
(Errcode: 13)
Only 18% of the disk are in use, df shows that there are 28'103'092 KB
||
| AUSCALLERID | tinyint(4) | | | 0 ||
containing 481484 records,
mysql yields
mysql CREATE INDEX INDX_ANSCHLUSS ON ANSCHLUSS(TELEFON, REGION, LAND,
NETZ);
ERROR 1: Can't create/write to file '/home/data/mysql/tmp/STabnagj'
(Errcode: 13)
Stephan,
tsp
table
Preparing columns_priv table
Installing all prepared tables
ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13)
ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13)
ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13)
ERROR: 1 Can't create/write
Liisa,
Thursday, August 29, 2002, 3:46:09 PM, you wrote:
LK Description:
LKproblem installing MySQL-3.23.52-1
LK How-To-Repeat:
LK shell rpm -Uvh MySQL-3.23.52-1.i386.rpm
[skip]
LK ERROR: 1 Can't create/write to file './mysql/db.frm' (Errcode: 13)
[skip]
It's a permission problem
Hi all,
While trying to upgrade a table struture i get the following error :
ALTER TABLE Prefixtest_T_Stories ADD COLUMN IndexDisplay char(1) default 'Y'
Error: 7 - Error on rename of '.\testbase\Prefixtest_t_stories.MYI' to
'.\testbase\#sql2-118-3.MYI' (Errcode: 13)
I m running a mysql 401
: David yahoo [EMAIL PROTECTED]
Date: Sat, 10 Aug 2002 16:09:02 -0600
To: Mysql [EMAIL PROTECTED]
Subject: Error: 7 - Error on rename ... (Errcode: 13)
Hi all,
While trying to upgrade a table struture i get the following error :
ALTER TABLE Prefixtest_T_Stories ADD COLUMN IndexDisplay char(1) default
-Original Message-
From: William dw [mailto:[EMAIL PROTECTED]]
Sent: Saturday, August 10, 2002 5:34 PM
To: Mysql
Subject: FW: Error: 7 - Error on rename ... (Errcode: 13)
Error code 13 = Permission denied.
Check your permissions :)
-Original Message-
From: David yahoo [mailto
Hello every one:
I have a problem modifying the structure of a table:
ALTER TABLE t_logs CHANGE log_id log_id INT(11) NOT NULL
AUTO_INCREMENT;
ERROR 1: Can't create/write to file './intranet/#sql-484_285.frm'
(Errcode: 13)
I made sure that the rights on the MYI, MYD and frm
LeTortorec, Jean-Louis a écrit :
Hello every one:
I have a problem modifying the structure of a table:
ALTER TABLE t_logs CHANGE log_id log_id INT(11) NOT NULL
AUTO_INCREMENT;
ERROR 1: Can't create/write to file './intranet/#sql-484_285.frm'
(Errcode: 13)
I made sure
smoothly. But when I start using the database,the following errorcode is
displayed
Can't read dir of './backedupdatabase/' (Errcode: 13)
I am able to create new database and use that one.
Can anybody pls help me out.
Thank U,
Nandakumar
using rpm file. Now i copied the
backedup datas to /var /lib/mysql directory.I can start the mysql daemon
smoothly. But when I start using the database,the following errorcode is
displayed
Can't read dir of './backedupdatabase/' (Errcode: 13)
I am able to create new database and use
Date |Fri, 24 Aug 2001 14:09:20 -0500
From |Tyler Longren [EMAIL PROTECTED]
Hello!
TL DROP TABLE Track
TL Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)
TL Anyone know what that means? As you can see, it came from tryign to do a
TL DROP on a table.
TL Thanks,
TL Tyler
It means mysql does not have write permission on the sports directory.
Grigory Bakunov wrote:
Date |Fri, 24 Aug 2001 14:09:20 -0500
From |Tyler Longren [EMAIL PROTECTED]
Hello!
TL DROP TABLE Track
TL Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)
TL Anyone know what
DROP TABLE Track
Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)
Anyone know what that means? As you can see, it came from tryign to do a
DROP on a table.
Thanks,
Tyler Longren
-
Before posting, please check
DROP TABLE Track
Error: 6 - Error on delete of '.\sports\track.ISD' (Errcode: 13)
Anyone know what that means? As you can see, it came from tryign to do a
DROP on a table.
Permission denied.
Maybe the dir permissions aren't correctly set up?
/ Carsten
--
Carsten H. Pedersen
keeper
the time:
Can't get stat of '/datenbank/ensembl/ensembl/Xref.txt.table'
(Errcode: 13), when using table: Xref
can anyone throw some light on the problem?
thanks,
Sean.
% perror 13
Error code 13: Permission denied
Looks like the server can't access the file. If the server is running
-
Ken Menzel ICQ# 9325188
www.icarz.com [EMAIL PROTECTED]
- Original Message -
From: Sean O'Keeffe [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 07, 2001 1:16 PM
Subject: errcode 13
hi there,
i've got a problem which someone might be able to help me
/ensembl/ensembl/Xref.txt.table'
(Errcode: 13), when using table: Xref
can anyone throw some light on the problem?
thanks,
Sean.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
/' (Errcode: 13)
Database changed
mysql show tables;
ERROR 12: Can't read dir of './thedb/' (Errcode: 13)
mysql
Error code 13 stands for permission denied. make sure the whole
MySQL data directory is owned by the same user you run the mysql
daemon as.
i'm not completely sure about the RPM
get the
following error:
mysql use thedb;
Can't read dir of './thedb/' (Errcode: 13)
Database changed
mysql show tables;
ERROR 12: Can't read dir of './thedb/' (Errcode: 13)
mysql
(RedHat 6.2, MySQL 2.23.37)
How can I recover or fix it?
Thanks in advance for any help.
K. Aleksic
recovery (errcode 13)?
Hi list,
I am dealing with my first MySQL server/db, and I ran into some trouble.
The server where the db was located got hacked and I had to reinstall the
whole thing. The old HD is preserved as was and the server got a new HD. I
moved the old db to the new disk and when I
errno 13 is 'permission denied'.
It looks like your permissions aren't set correctly.
-Jeff
- Original Message -
From: Kay Aleksic [EMAIL PROTECTED]
To: MySQL List (E-mail) [EMAIL PROTECTED]
Sent: Wednesday, May 09, 2001 3:10 PM
Subject: database recovery (errcode 13)?
Hi list,
I
and when I try to access it, I get the
following error:
mysql use thedb;
Can't read dir of './thedb/' (Errcode: 13)
Database changed
mysql show tables;
ERROR 12: Can't read dir of './thedb/' (Errcode: 13)
mysql
I have seen this error when the database (which exists as a directory
I am sending this again since the first time I sent it I wasn't entirely
signed in to the list.
I am running RedHat linux 7.1 and MySQL 3.23.37. I am trying to use
mysqlimport and am getting an error message mysqlimport: Error: Can't get
STAT of /path/to/file/file (Errorcode: 13) , when
I am running RedHat linux 7.1 and MySQL 3.23.37. I am trying to use
mysqlimport and am getting an error message mysqlimport: Error: Can't get
STAT of /path/to/file/file (Errorcode: 13) , when using table: table_name.
I looked the error up in the on-line documentation and changed the UMASK and
'/home/laovision/lvdb/region.dat'
- into table tlu_region fields terminated by '\t';
ERROR 13: Can't get stat of '/home/laovision/lvdb/region.dat' (Errcode: 13)
I get same error using mysqlimport
Any help would great.
Thanks,
Kalvin
I keep getting the following error everytime i tried to use Load Data
mysql load data infile '/home/laovision/lvdb/region.dat'
- into table tlu_region fields terminated by '\t';
ERROR 13: Can't get stat of '/home/laovision/lvdb/region.dat' (Errcode: 13)
I get same error using mysqlimport
67 matches
Mail list logo
