mysql dump speed

[dan orlic]

I have a bit of an issue with mysqldumps and inserting it back into
mysql.
 
Granted, I have 1 table that has over 1Million entries, but generating
these tables takes about 3 hours with a java app.
But when I do a mysql -u root -p < <the mysql dump.dmp> it is taking
about 28 hours to complete the load.
 
Can anyone tell me what is taking so long?  Any thoughts as how to speed
it up?  Thanks in advance.
 
 
Dan orlic