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 INT,
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
4 /usr/sbin/mysqld {
5#include
6#include
7#include
8#
t;
> Huh, maybe the daemon doesn't 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
/tmp/make_year_model.csv' INTO TABLE
vehicles.vehicles FIELDS 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
#x27; or '\h' for help. 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&#
; for help. 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): F
27;\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 &
gt;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'
NES 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 now
make2,model2,2013,780,need to sell
make3,model3,2001,780,cheap
thufir@dur:~$
thanks,
Thufir
fix the problem?
>
> mysql -ugenome -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/m
On Tue, Jan 18, 2011 at 6:24 AM, sushant chawla 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 partition
>
Also, make
t; > 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)
> >
> > --
>
art, 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://lists.mysql.com/mysql?unsub=yogeshk...@gmail.com
>
>
-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)
--
Regards,
Peng
--
MySQL General Mailing
'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 &#x
:
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
te 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/
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]
ed1_p2.txt'
(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
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
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
ECTED]>
cc: MySql
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 soluti
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
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 canno
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 ment
8:43:11 [Warning] Can't create test file
/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 a
g] Can't create test file
/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
reate 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 adva
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.
--
MySQL Gene
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&
; 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 start with error:
> >
> > "Can't create/write to file '/root/tmp/ibu6vdue' (Errcode: 13)&q
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
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
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: Operat
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.
-
Befor
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
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
| 0 ||
> >>>| ANZAHLANRUFE | int(11) | | | 0 ||
> >>>| AUSCALLERID | tinyint(4) | | | 0 ||
> >>>
> >>>containing 481484 records,
> >>>
> >>>mysql
;>>
>>>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
ATE 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
>
>
| int(11) | | | 0 ||
> | AUSCALLERID | tinyint(4) | | | 0 ||
>
> containing 481484 records,
>
> mysql yields
>
> mysql> CREATE INDEX INDX_ANSCHLUSS ON ANSCHLUSS(TELEFON, REGION, LAND,
> NETZ);
> ERROR 1: Can'
||
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
Liisa,
Thursday, August 29, 2002, 3:46:09 PM, you wrote:
LK> Description:
LK>problem 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' (Errcod
bles_priv 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.f
-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
omis
From: "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 Prefixtes
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&#
"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 './
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 M
ysql version 3.23.33 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:
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
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
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
> 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 s
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, pl
-
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
'm getting the following error all 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
stat of '/datenbank/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/man
;
> Can't read dir of './thedb/' (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 directo
I
> moved the old db to the new disk 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/&#
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
database 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 an
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?
Than
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
l> 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 usin
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
67 matches
Mail list logo
