Home / server / Questions / 282453
Accepted
Ankur
Asked: 2011-06-21 19:19:12 +0800 CST

MySQL can't write to tmp folder, how do I find this tmp folder

  • 772

MySQL (using MAMP) says it can't write to Can't create/write to file '/private/var/folders/AO/AOyal7b0GU844L1VJDb3Bk+++TI/-Tmp-/#sqld035_6_0.MYI

But using finder I can't find this location. How can I find this location so I can clear it.

mysql filesystems find mamp

1 Answers

  1. Best Answer
    mysql> show variables like 'tmpdir';
+---------------+----------------------------------------------------+
| Variable_name | Value                                              |
+---------------+----------------------------------------------------+
| tmpdir        | /var/folders/v+/v+g2dk4fH8qEA4rg+GeRNk+++TI/-Tmp-/ |
+---------------+----------------------------------------------------+
1 row in set (0.00 sec)
    • 3