How do I fix the mysqli error about my Temp File?

2011-10-04 11:48:26Tags: mysqli

Answer:

Should Logaholic upon updating generate errors that mention your temp file (tmp), it could look something like this:

mysqli error: [126: Incorrect key file for table '/tmp/#sql_5896_0.MYI'; try to repair it]

Most likely you run out of disk space because of an over inflated temp file that MySql needs to import your log file.

Since the default temp file sits on a specific partition, enlarging can be complicated. A better strategy to solve this problem is to edit the MySql my.ini or my.cnf file :

Below is a sample piece of my.ini or my.cnf file (MySQL 4.1)

# The following options will be passed to all MySQL clients
[client]
socket=/tmp/mysql.sock


# The MySQL server
[mysqld]
tmpdir=/tmp Change this location. to where you have sufficient disk space.
socket=/tmp/mysql.sock
skip-locking
skip-networking
skip-name-resolve

server-id=1

max_connections=500
key_buffer_size=384M
max_allowed_packet=16M
table_cache=256
etc etc etc...
The information on this page relates to older Logaholic versions (prior to Logaholic 6) and may be outdated.