CLI Upgrade MySQL query error [1878]: Temporary file write failure.

Upgrading a licensed client via CLI getting the error "xf_liked_content: MySQL query error [1878]: Temporary file write failure."

Host says "We changed the MySQL temp directory location under / directory which has 287G free space"

How can I resolve this.
 
mysql> SHOW VARIABLES WHERE Variable_name='tmpdir';
+---------------+-------------------+
| Variable_name | Value |
+---------------+-------------------+
| tmpdir | /home/mysqltmpdir |
+---------------+-------------------+
 
Top