mysql error?? Error: Can't create/write to file '\#sql2a_52_0.MYI' (Errcode: 13)

[Sarah]

I ahve just got thisnew error

Error: Can't create/write to file '\#sql2a_52_0.MYI' (Errcode: 13)

on a system that has been working for months.. I reloaded a new dB and a backup ciopy and this happened.

On a different machine with same dB and same code it works fine

any ideas guys?

Sarah

[Technosailor]

I assume you're using Windows...

open your MySQL my.cnf file and under [mysqld] make sure you have tmpdir=your temporary directory. Something like

[mysqld]
tmpdir=c:/temp

Alternatively, for Linux (or Windows for that matter) run

mysqld --tmpdir=\tmp (or whatever your temp folder is)


HTH.

Sketch

[Sarah]

Okay.. yes win NT (sorry)

firstly

where is my.cnf file??

also did the

mysqld --tmpdir=c:/temp

and

mysqld --tmpdir=/temp

and it just says

can't initialize InnoDB as 'innodb_data_file_path' is not set

and then does nothing I have to close the prompt down to get a prompt back??




Sarah

[Technosailor]

it should be in your c:/mysql or whatever directory your mysql is in...Not exactyl sure if it's in a subdir or not...you'll have to look./ I'm not at home right now or I'd look.

sketch

[seanf]

Wrong forum Sarah!

Sean

[Technosailor]

how so?! It's in the Files, DATABASES, and XML forrum..

Sketch

[Mark T.]

Psst, Aaron: http://www.sitepointforums.com/forum...?s=&forumid=34

Tom-die-dom-die-die-die-dom ...

[Technosailor]

Ignore the man behind the curtain...

Sorry, Sean

Sketch

[Mark T.]

Anyway, Sarah, with a typical install of MySQL, the my.cnf file should be somewhere in your system root. Try looking in C:/my.cnf. It sits there nice and quitly with me .

[seanf]

Originally posted by Sketch
Sorry, Sean

That's ok!

Sean

[DR_LaRRY_PEpPeR]

MySQL doesn't install any my.cnf/my.ini by default. check C:\ for my.cnf or Windows\ on 9x or WINNT\ on NT for my.ini. see if you have `tmpdir=path' under the `[mysqld]' section. if you do, try removing it (since mysqld should use the system's temp directory by default), or point it to a directory that you know exists. you can see where the tmpdir is currently with this query:

SHOW VARIABLES LIKE 'tmpdir';

[redemption]

Originally posted by Mark T.
Psst, Aaron: http://www.sitepointforums.com/forum...?s=&forumid=34

Tom-die-dom-die-die-die-dom ...

now that was funny lol

the my.cnf file, if you can't find it in your root directory (c:\) as my.cnf, or in your winnt directory as my.ini, would be available in your mysql folder (probably c:\mysql)... it's probably named my-example.cnf or my-small.cnf (and a few others)... pick the one that suits you best, make a copy of it, rename it to my.cnf, make your changes, then place it in your root directory (you can also rename it to my.ini and place it in your winnt dir)

that's in the off-chance that it isn't already there

[DR_LaRRY_PEpPeR]

i don't like any of those my-xxx.cnf's. the variables are either too small or too big. i would just recommend using this as a "base" my.cnf:

[mysqld]
# Uncomment and change the next line if you installed
# MySQL somewhere other than the default C:/mysql
#basedir=C:/mysql
port=3306
skip-locking
set-variable = table_cache=512
set-variable = thread_cache_size=8
set-variable = wait_timeout=3600

[client]
port=3306
# Here you can put your username and password
# if you want so that you don't have to manually
# enter them when using mysql, mysqldump, etc.
# Uncomment the lines if you do!
#user=<username>
#password=<password>

[mysql]
no-auto-rehash

[mysqldump]
quick

and of course in this case add `tmpdir=path' if you need it under [mysqld].

[Sarah]

sorry sean was having a bad day and I lumped it with php see other thread in php forum where H kindly took the **** out of me too !!! I'm blonde [and hungover today] thats all I can say in my defense

cheers sketch, Mark, dr_larry_peper, redemption

that sample file you gave me worked a treat thank you so much (I added in tmpdir didn't like it if I didn't)

cheers resolved a nasty problem that would have slowed me up all day..

's all round [on me of course]

Thanks

Sarah

[seanf]

What about skip-innodb Matt?

Don't worry Sarah

Sean

[DR_LaRRY_PEpPeR]

Originally posted by seanf
What about skip-innodb Matt?

well yeah, add that too under [mysqld] if you're using a version of MySQL with InnoDB support (-max probably...?) and don't want to use it, or if you're getting errors about starting InnoDB.