I have a table in MySQL with ~2,000,000 rows.
When I try to select all records, it exhausts the system's memory and I get an error about memory exhaustion back.
When I try to use the MySQL
LIMIT and select 1,000 records, the error in the title is returned:
General error: 126 Incorrect key file for table '/tmp/#sql_27e6_0.MYI'; try to repair it'
What's the best course of action to export all of the data in this table? Why is it returning an error when only trying to pick 1,000 records?
select * from notes order by id asc limit 1000