My host (dedicated) server says 24 hour response time, so far it has been 49 hours and counting so looks like I will just do this myself, I need to find out what my tmp_table_size is then most likly increase it, how do I do this?

Have you tried http://www.google.com/search?q=set+mysql+tmp_table_size ?