Re: (Errcode: 13) after moving data directory

boll wrote: Dominik Klein wrote: Did you check FAT-permissions? When mounting a FAT-partition, you have to set explicit permissions while mounting as FAT does not understand the unix permission concept. Try to mount this way: mount -t vfat -o uid=mysql,gid=mysql,rw,umask=007 /dev/[yourdev

Re: (Errcode: 13) after moving data directory

Dominik Klein wrote: Did you check FAT-permissions? When mounting a FAT-partition, you have to set explicit permissions while mounting as FAT does not understand the unix permission concept. Try to mount this way: mount -t vfat -o uid=mysql,gid=mysql,rw,umask=007 /dev/[yourdevicename] /your

Re: (Errcode: 13) after moving data directory

boll schrieb: Hi- Using MySQL 4.1.11 on Fedora 4. I moved my data directory to a FAT partition in order to share it with Windows dual-boot. Now when I try to start mysqld normally, it fails with these messages in the log: 060420 18:16:03 mysqld started 060420 18:16:03 [Warning] Can't create

RE: Errcode: 27

Sorry me again! I haven't had any success with this thread :( But could someone at least tell me the best way to debug this please? Are there any options I can provide to increase the logging detail? Thanks, JS. Does anyone know what goes on (system wise) during the CREATE INDEX ? I can see it'

RE: Errcode: 27

Does anyone know what goes on (system wise) during the CREATE INDEX ? I can 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 a

RE: Errcode: 27

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) -- CREATE INDEX timeindex ON internet_usage

RE: 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 the specifics of what happen

Re: Errcode: 27

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 filesystem. This shoul

Re: Errcode: 27

This should be a useful thread for you http://lists.mysql.com/mysql/167953 Suggests using ALTER TABLE MAX_ROWS= On Fri, 23 Jul 2004 20:20:24 +, "J S" <[EMAIL PROTECTED]> wrote : > Hi, > > I'm trying to run the following SQL (on > mysql-max-4.0.20-ibm-aix4.3.3.0-powerpc): > > CREA

Re: Errcode: 13

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' (Errcode: 13) [skip] It's a permission probl

Re: Errcode

The file permissions are wrong. Log in as root change to the directory where the mysql databases are stored, and reset the file permissions. something like cd /usr/local/var/mysql #make this line where ever you databases are chown -R mysqluser * # change mysqluser to the username yo

Re: Errcode:13

You coppied it as root, and mysql does not own it. chown -R mysql /var/lib/mysql Nandakumar wrote: > Hi all, > I am working on Redhatversion 6.2. I used Mysql version 3.22.xx > before . I took the back up of all datas. I formatted my machine 2 weeks > back. I installed mysql version 3.23

Re: Errcode: 2 when running LOAD DATA LOCAL INFILE on server

Post a couple of lines from your data file. Does .csv insist on all values single quoted? On Thu, Aug 16, 2001 at 09:03:36PM -0700, Yeong CN wrote: > Hi. > This is the script I write to upload a .csv file into my online mysql database : > > $sql_query="LOAD DATA LOCAL INFILE '$textfile' INTO

Re: errcode 2 message with "load data local infile"

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

Re: errcode 2 message with "load data local infile"

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

Re: errcode 2 message with "load data local infile"

Dave Fogle writes: > Thanks for reading this - I have searched all the MySQL info I can find as > well as the web at large, but nobody seems to have offered a real answer to > the following problem, which many have had, though possibly only with Win32 > client machines accessing UNIX servers: > >

Re: errcode 13

Sounds like you have a problem with the .frm file. Try checking the permission of xref.txt.frm or some part of that. Try making sure it is set to the proper owner with read and write permissions (usually mysql or mysqladmin is the owner). Best of luck Ken

Re: errcode 13

At 7:16 PM +0200 6/7/01, Sean O'Keeffe wrote: >hi there, >i've got a problem which someone might be able to help me with. >i'm importing text files into a database in mysql using mysqlimport : > /users/mysql/bin/mysqlimport -u * databasename *.txt >however i'm getting the following error a