Take the 2-minute tour ×  I'm running MySQL Server 5.5.20 on
Windows 7 64-bit with 16GBs of ram. When I do a select * on a 5m
record table in Workbench, I get Error code 2008 Client of
Memory. I can't view my entire table so that I can export it.
ODBC connections give me the same Out of Memory Errors. Is there
a set of variables that I can change that stop this?  I've tried
so many different things, and yes, it is important for me to
return all fields and all records in this table. Does anyone
have any suggestions?  share|improve this question what is the
exact query that you are using? It may be looping and then
eating up all your memory until it errors out. –  Salmonerd Aug
13 '12 at 15:04 my query is simply: select * from table – 
user1236443 Aug 13 '12 at 15:11 does it still error out if you
try selecting just one field in the table. Select field From
table ??? –  Salmonerd Aug 13 '12 at 15:16 Yes it works if I
select only 1 field. –  user1236443 Aug 13 '12 at 15:18 Ok how
about you try writing out all th