Webmaster2020.com

Posted: **Wed Nov 09, 2016 9:17 pm**

Hi,

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

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.

Posted: **Wed Nov 09, 2016 9:32 pm**

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

Webmaster2020.com

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

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

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