Mysql::Error: Incorrect key file for table '/tmp/#sql_2650_0.MYI'; try to repair it: SELECTmaps.* FROMmapsINNER JOINwarpablesON warpables.map_id = maps.id WHERE (maps.password= '' ANDmaps.archived= 0) GROUP BY maps.id ORDER BY updated_at DESC
First tried to back up the db with mysqldump -u root -p cartagen_production > mapknitter-2013-08-13.sql
It returned: mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'exports'': Got error 28 from storage engine (1030)
Then, trying to open the mapknitter directory in vim, i got E297: Write error in swap file
Mysql::Error: Incorrect key file for table '/tmp/#sql_2650_0.MYI'; try to repair it: SELECT
maps.* FROM
mapsINNER JOIN
warpablesON warpables.map_id = maps.id WHERE (
maps.
password= '' AND
maps.
archived= 0) GROUP BY maps.id ORDER BY updated_at DESC
First tried to back up the db with
mysqldump -u root -p cartagen_production > mapknitter-2013-08-13.sql
It returned:
mysqldump: Couldn't execute 'SHOW TRIGGERS LIKE 'exports'': Got error 28 from storage engine (1030)
Then, trying to open the mapknitter directory in vim, i got
E297: Write error in swap file