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
Daevid Vincent <[EMAIL PROTECTED]> wrote:
> mysql> use mydbB;
> mysql> CREATE TABLE foo ( id int(10) unsigned NOT NULL auto_increment, name
> varchar(255) NOT NULL, PRIMARY KEY id (id) );
> ERROR 3 (HY000): Error writing file './mydbB/foo.frm' (Errcode: 5)
>
mysql> CREATE TABLE foo ( id int(10) unsigned NOT NULL auto_increment,
> name
> varchar(255) NOT NULL, PRIMARY KEY id (id) );
> ERROR 3 (HY000): Error writing file './mydbB/foo.frm' (Errcode: 5)
>
> mysql> use mydbA;
> mysql> CREATE TABLE foo ( id int(10) u
ldn't re-create the table again. So breaking it down to basic level...
mysql> use mydbB;
mysql> CREATE TABLE foo ( id int(10) unsigned NOT NULL auto_increment, name
varchar(255) NOT NULL, PRIMARY KEY id (id) );
ERROR 3 (HY000): Error writing file './mydbB/foo.frm' (Errcode: 5)
Hi there,
Is it true that problems related to error 11 are most likely bugs in MySQL?
I have a query involving a union statement with a group and order by
statement around it. The total data that has to be handled by the union
statement is in the 100,000 or millions rows. I am using Windows X
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
#x27;t open privilege tables: File
> '/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)
>
> I would like it to load the latin1.conf charset.
>
> I can't find any variable that influences this choice. Probably there
> is something not configured
n immediately.
The following error is presented to me:
Fatal error: Can't open privilege tables: File
'/usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)
I would like it to load the latin1.conf charset.
I can't find any variable that influences this choice. Probably the
usr/local/share/mysql/charsets/?.conf' not found (Errcode: 2)
I would like it to load the latin1.conf charset.
I can't find any variable that influences this choice. Probably there
is something not configured or the configuration isn't supported.
Anyway I would like to know how t
-P -u
-- MySQL dump 8.23
--
-- Host: localhost Database:
-
-- Server version 3.23.58-log
/usr/local/mysql/bin/mysqldump:
Got error: 1105: File '/usr/local/mysql/var/atmail/Abook_vx.MYD' not found
(Errcode: 24) when
see it's copying the table file, what then though?
Hi, I'm stuck on this really badly. Can anyone help me out please?
Thanks,
JS.
I tried running the "create index" again using --verbose but this is all
I got:
ERROR 3 at line 1: Error writing file '/proxydb/mys
all I
got:
ERROR 3 at line 1: Error writing file '/proxydb/mysql/tmp/STLd39Et'
(Errcode: 27)
--
CREATE INDEX timeindex ON internet_usage (uid,time)
--
Bye
Can anyone tell me the specifics of what happens during the create index?
I can see that the table bein
Hi, I'm stuck on this really badly. Can anyone help me out please?
Thanks,
JS.
I tried running the "create index" again using --verbose but this is all I
got:
ERROR 3 at line 1: Error writing file '/proxydb/mysql/tmp/STLd39Et'
(Errcode: 27)
--
I tried running the "create index" again using --verbose but this is all I
got:
ERROR 3 at line 1: Error writing file '/proxydb/mysql/tmp/STLd39Et'
(Errcode: 27)
--
CREATE INDEX timeindex ON internet_usage (uid,time)
--
Bye
Can anyone tell me t
Thanks but that's not v helpful. Actually that was my thread! The problem
there was that I didn't have a large-file enabled filesystem. The problem I
have now is being able to create another index on a table but getting an
errcode 27 despite no ulimits and a large enabled filesys
max-4.0.20-ibm-aix4.3.3.0-powerpc):
>
> CREATE INDEX timeindex ON internet_usage (time);
> CREATE INDEX urlindex ON internet_usage (urlid);
>
> but keep running into the following error:
>
> Error writing file '/proxydb/mysql/tmp/STeR39Er' (Errcode: 27)
>
> $ perr
Hi,
I'm trying to run the following SQL (on
mysql-max-4.0.20-ibm-aix4.3.3.0-powerpc):
CREATE INDEX timeindex ON internet_usage (time);
CREATE INDEX urlindex ON internet_usage (urlid);
but keep running into the following error:
Error writing file '/proxydb/mysql/tmp/STeR39Er
Yes you can.
-Original Message-
From: J S
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 7/16/04 8:35 AM
Subject: RE: ERROR 3 at line 1: Error writing file
'/proxydb/mysql/tmp/STTbtrac' (Errcode: 27
>
>Yes. Can you
>CREATE TEMP TABLE ?
I managed this:
mysq
essage-
From: J S
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 7/16/04 7:34 AM
Subject: RE: ERROR 3 at line 1: Error writing file
'/proxydb/mysql/tmp/STTbtrac' (Errcode: 27
>Can you explicitly create temporary tables?
Yes, I have full priviledges. Do you mean I could copy the
internet_us
Yes. Can you
CREATE TEMP TABLE ?
-Original Message-
From: J S
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: 7/16/04 7:34 AM
Subject: RE: ERROR 3 at line 1: Error writing file
'/proxydb/mysql/tmp/STTbtrac' (Errcode: 27
>Can you explicitly create temporary tables?
Yes
'/proxydb/mysql/tmp/STTbtrac' (Errcode: 27
>>Are you files being created in /tmp? How big is this partition?
>
I wondered about that, but I've set the mysql tmpdir to
/proxydb/mysql/tmp, and the error does actually say: Error writing
file '/proxydb/mysql/tmp/STTbtrac'
A
Can you explicitly create temporary tables?
-Original Message-
From: J S
To: [EMAIL PROTECTED]
Sent: 7/16/04 3:54 AM
Subject: RE: ERROR 3 at line 1: Error writing file
'/proxydb/mysql/tmp/STTbtrac' (Errcode: 27
>>Are you files being created in /tmp? How big is thi
27;s tricky isn't it?!
JS.
-Original Message-
From: J S
To: [EMAIL PROTECTED]
Sent: 7/15/04 2:29 PM
Subject: ERROR 3 at line 1: Error writing file
'/proxydb/mysql/tmp/STTbtrac'
(Errcode: 27
Hi,
I'm trying to create an index using the command:
CREATE INDEX urlindex ON
27;s tricky isn't it?!
JS.
-Original Message-
From: J S
To: [EMAIL PROTECTED]
Sent: 7/15/04 2:29 PM
Subject: ERROR 3 at line 1: Error writing file
'/proxydb/mysql/tmp/STTbtrac'
(Errcode: 27
Hi,
I'm trying to create an index using the command:
CREATE INDEX urlindex ON
Are you files being created in /tmp? How big is this partition?
-Original Message-
From: J S
To: [EMAIL PROTECTED]
Sent: 7/15/04 2:29 PM
Subject: ERROR 3 at line 1: Error writing file '/proxydb/mysql/tmp/STTbtrac'
(Errcode: 27
Hi,
I'm trying to create an index using the c
line 1: Error writing file '/proxydb/mysql/tmp/STTbtrac'
(Errcode: 27)
perror says:
$ perror 3
Error code 3: The process does not exist.
$ perror 27
Error code 27: A file cannot be larger than the value set by ulimit.
$
I'm using mysql-max-4.0.20-ibm-aix4.3.3.0-powerpc on ai
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
does anybody know what this means? My binlogs are full of them.
thanks,
- Mark
sql
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To r
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
Andreas,
Thursday, September 12, 2002, 3:56:58 PM, you wrote:
AM> After a query
AM> SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY
AM> ENCLOSED BY '"' FROM testtable
AM> the following error occurs:
AM> Error writing file
perror 28
Error code 28: No space left on device
Andreas Metzner wrote:
>Hi All,
>
>After a query
>SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY
>ENCLOSED BY '"' FROM testtable
>
>the following error occurs:
>
Hi All,
After a query
SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"' FROM testtable
the following error occurs:
Error writing file 'test.csv' (Errcode: 28)
The file was written partially indeed, but not includin
Hi All,
After a query
SELECT * INTO OUTFILE "test.csv" FIELDS TERMINATED BY ',' OPTIONALLY
ENCLOSED BY '"' FROM testtable
the following error occurs:
Error writing file 'test.csv' (Errcode: 28)
The file was written partially indeed, but not includin
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&#
erence
>- check data record references index: 1
>myisamchk: Can't unlock file (Errcode: 11)
>- check record links
>myisamchk: error: 11 when locking indexfile '../data/test/customer'
>
>Can anybody tell me what actually is this error?
>
>***
lients is using or hasn't closed the table properly
- check file-size
- check key delete-chain
- check record delete-chain
- check index reference
- check data record references index: 1
myisamchk: Can't unlock file (Errcode: 11)
- check record links
myisamchk: error: 11 when locking inde
"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
Hi
Environment
Mysql ver. 3.23.36
Mysqldump ver. 8.13
Solaris 2.7
Problem
I have been trying to use mysqldump --tab to dump a database of
93 records but it always fails on the 61st table with the following
error code
mysqldump: Can't create/write to file '/bu/fred.sql
you use
to run mysql
This will set permissions on all log files and databases.
Ken
- Original Message -
From: "Wild !" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, September 25, 2001 9:23 AM
Subject: Errcode
> When I try to alter a field in my t
When I try to alter a field in my table, I get the following error. I have all
permissions. Please Help
Failed to save field : SQL alter table employees modify employee_id smallint(4)
unsigned not null auto_increment failed : Can't create/write to file
'./employees/#sql-13c_ab.frm
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
gt; When I try to run the script in localhost, it is work.But when I try in the
>server,it can't work and return the error message like that :
>
> Error : LOAD DATA LOCAL INFILE 'C:\\purchase3.csv' INTO TABLE purchase FIELDS
>TERMINATED BY ','
>(purchase_ord
TERMINATED BY ','
(purchase_order,job_no,username,model,quantity,due_date,sent_date,courier_service,remark)
File 'C:\purchase3.csv' not found (Errcode: 2)
I think it maybe the backsplashes that make the error occur..
so I change the script like that :
$sql_query=strips
Dave Fogle writes:
> Thanks for responding, but the full path is not the answer.
>
> I have tried every conceivable full path (see original message) and it does
> not help. In fact, the only thing that has ever worked was using no path
> info and putting the file in the root of the C: drive on m
Thanks for responding, but the full path is not the answer.
I have tried every conceivable full path (see original message) and it does
not help. In fact, the only thing that has ever worked was using no path
info and putting the file in the root of the C: drive on my local machine.
But for some
INFILE "filename.txt" INTO TABLE tablename;"
> results in the error: "File 'filename.txt' not found (Errcode: 2)"
>
> Thanks for listening
Solution to your problem is quite simple.
Simply set a full path of the file.
--
Regards,
__ ___ ___
in the error: "File 'filename.txt' not found (Errcode: 2)"
Now, let me point out that I actually got this to work at one point, by
putting the files in the root of my C: drive and using just the filename
with no path info. The files were found and uploaded and the tables filled
wi
-
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/&#
1 - 100 of 117 matches
Mail list logo
