Ok, problem solved. I checked the mysqld.log file and it showed the 28 out of space error. It looks like the /tmp folder was not allowing mysql to write files to it for temp use because it was full. I solved this by created /mysqltmp with 777 permissions and then adding tmpdir=/mysqltmp to the my.cnf. The next time I ran the import, it completed in under 10 mins.
Hope this threads helps someone in the future!
Jason
Last edited by p74vic; 02/15/2009 5:05 AM.
