Page 1 of 1

mySQL probs

PostPosted: 22. October 2003 12:53
by squallflight
I'm running Windows 2000 with the latest version of Xampp. I understand that you need my.cnf in C:\ to run mysql on 2000 and still it doesn't work

I have a file in C: called my.cnf and I've gone through mysql_installservice and followed the instructions but still mysql doesnot work.

this is what my.cnf contains:
Code: Select all
# The MySQL client
#password       = your_password
port            = 3306
socket          =D:/xampp/mysql/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
port            = 3306
socket          = D:/xampp/mysql/mysql.sock
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
server-id       = 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

# Uncomment the following if you are using InnoDB tables
#innodb_data_home_dir = D:/xampp/mysql/
#innodb_data_file_path = ibdata1:10M:autoextend
#innodb_log_group_home_dir = D:/xampp/mysql/
#innodb_log_arch_dir = D:/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
#set-variable = innodb_lock_wait_timeout=50

set-variable    = max_allowed_packet=16M

# Remove the next comment character if you are not familiar with SQL

set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M

set-variable    = key_buffer=20M
set-variable    = sort_buffer=20M
set-variable    = read_buffer=2M
set-variable    = write_buffer=2M



please help

PostPosted: 22. October 2003 12:55
by squallflight
maybe I should also say that XAMPP is installed in D:/xampp/ as that drive has more space

PostPosted: 22. October 2003 13:55
by Kristian Marcroft

when you go on Start -> Run -> cmd and call mysql so start via the command shaell, what error appears on the Screen?
What does the mysql log tell you?
You can find it here:
it's called <hostname>.err
Hostname is your Name of the Computer...
Check that, and then post the messages here.

So long

PostPosted: 22. October 2003 14:25
by squallflight
s'ok now, i reinstalled xampp and wrote my.ini in winnt folder and it all works now
this is what the ini file says:
Code: Select all

thanks anyway

PostPosted: 28. January 2005 05:46
by komakoma
it said

InnoDB: Error: unable to create temporary file; errno: 13