MySQL error or something!

[TheMajor]

Hi folks,

Sometimes when clicking "Who's online" I get the following error. I also get it when clicking "Permissions" for one of my forum categories. It says something about xampp but I do not have xampp....Please help me.

This is th one I get when trying to change permissions:

Can't create/write to file '\xampp\tmp\#sql_7dc_0.MYI' (Errcode: 2)
File: d:\mijn documenten\websites\themajor-server\forums\smf\Sources\ManagePermissions.php
Line: 151

My server specs:
Apache 1.3.31 W32
PHP 4.3.9
MySQL 4.0.21

Running on FAT32/XP Pro

[Oldiesmann]

Make sure the \tmp directory is chmodded to 666 or 777 (preferably 777).

[TheMajor]

2 stupid questions:

-where can I find the \tmp folder? is it in the htdocs, mysql or php folders? is it located in \xampp? I cannot find them.
-How do I chmod without FTP?

thanks

[Oldiesmann]

Looks like \tmp is in \xampp.

Second question - talk to your host about this since you can't find \xampp and you can't really CHMod stuff on a Windows server anyway...

[TheMajor]

I am running the server on my own computer so I can change anything you want.

I searched the apache root folder, the php folder and the mysql folder and the htdocs folder and neither xampp or tmp exist.

I noticed that xampp is entered n my.ini
Should I change anything here?:

# The MySQL client
[client]
# password       = *********************
port            = 3306
socket          = mysql

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port            = 3306
socket          = mysql
skip-locking
set-variable    = key_buffer=16M
set-variable    = max_allowed_packet=1M
set-variable    = table_cache=64
set-variable    = sort_buffer=512K
set-variable    = net_buffer_length=8K
set-variable    = myisam_sort_buffer_size=8M
log-bin
server-id       = 1

basedir=D:/Programma's/Apache/mysql
tmpdir=/xampp/tmp
datadir=D:/Programma's/Apache/mysql/data

#bind-address=192.168.1.1
#log-update     = /path-to-dedicated-directory/hostname

# Uncomment the following if you are using BDB tables
#set-variable   = bdb_cache_size=4M
#set-variable   = bdb_max_lock=10000

skip-innodb
# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = /xampp/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = /xampp/mysql/
#innodb_log_arch_dir = /xampp/mysql/
# You can set .._buffer_pool_size up to 50 - 80 %
# of RAM but beware of setting memory usage too high
#set-variable = innodb_buffer_pool_size=16M
#set-variable = innodb_additional_mem_pool_size=2M
# Set .._log_file_size to 25 % of buffer pool size
#set-variable = innodb_log_file_size=5M
#set-variable = innodb_log_buffer_size=8M
#innodb_flush_log_at_trx_commit=1
#set-variable = innodb_lock_wait_timeout=50

[mysqldump]
quick
set-variable    = max_allowed_packet=16M

[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates

[isamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[myisamchk]
set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

[mysqlhotcopy]
interactive-timeout

[WinMySQLadmin]
Server=D:/Programma's/Apache/mysql/bin/mysqld-nt.exe

[TheMajor]

I think i found it!

this:
tmpdir=/xampp/tmp

has to be changed to:
tmpdir=/some existing directory

right?

[Oldiesmann]

Yep.

[TheMajor]

i changed it to

/tmp

and created a tmp folder in /mysql

didn't work

also tried in /mysql/data, /mysql/bin, c:/tmp

I am clueless.

wich folder do I need to put it?

Only God can help me.

The error changed to Can't create/write to file '\tmp\#sql_588_0.MYI' (Errcode: 2) after setting /tmp in my.ini

[Oldiesmann]

Make sure that the directory you create is accessible and writeable by everyone. If you use \tmp, then you'll need to make sure that tmp exists in the directory MySQL is in.

[TheMajor]

i installed mysql in d:/............./Apache/mysql

should the tmp be located here?
Apache/mysql/tmp
or here?
Apache/tmp

how do I make sure everbody can write and read it? should i set up an FTP server and chmod the tmp directory?

[Oldiesmann]

Apache/mysql/temp

Not sure about the other one. I'm not real familiar with Apache for Windows.

[TheMajor]

I installed mysql again...i noticed during installation i have to make a seperate my.ini file in Windows folder when installing mysql in any other folder than default (c;/mysql) the ini i created contains base dir and data dir

hope it works now

[TheMajor]

ok...it works...no more errors

Thanks for helping!

[Oldiesmann]

No problem. Glad you got it fixed.

[TheMajor]

Lol man, this post is about 1 year old!!! :D:D:D
Btw, my server runs fine!
I am not using Xammp anymore, just plain Apache/PHP/MySQL etc.

[dtm.exe]

Lol man, this post is about 1 year old!!! :D:D:D
Btw, my server runs fine!
I am not using Xammp anymore, just plain Apache/PHP/MySQL etc.

Glad to hear it .