MySQL incorrect key file for tmp table when making multiple joinsI don't come here for help often but I am pretty frustrated by this and I am hoping someone has encountered it before. Whenever I try to fetch records from a table using more than one join I get this error: #126 - Incorrect key file for table '/tmp/#sql_64d_0.MYI'; try to repair it So this query will produce the error: SELECT * FROM `core_username` INNER JOIN `core_person` ON (`core_username`.`per
Planet MySQL :: Planet MySQL - Archives - How To – Resolve MySQL Error Incorrect Key File ...
Magento Forums
