MYSQL ERROR 1878 (HY000): Temporary file write failure.

[mister_v]

Hi,

I have the following error in MySQL,
when I do an alter statement:

Code: Select all

ERROR 1878 (HY000): Temporary file write failure.

the Alter command:

Code: Select all

ALTER TABLE f_inside_trade ADD COLUMN source TINYINT UNSIGNED;

Anyone know what the reason is?
Its the first time I get this error.

[chris]

When you do a ALTER TABLE in MySQL it re-create the table,
so two copies of the table exists on the system.

So you need enough free space.
specially in /tmp/
Because this dir is used as default.
you can change it in /etc/mysql/my.cnf

Code: Select all

tmpdir          = /tmp