MySQL .sql file import

[woolyg]

Hi all,

 

I've done a mysql backup of a table to a .sql file that's 5MB in size. Upon attempting to import the .sql file using PHPmyadmin, my web server hangs, and the PHPMyadmin page goes blank, and the CPU Usage goes up to 50%.

 

The .sql file size is under that specified allowed in the import, and my timeout is set to 0 for no limit, as I'd like to import files much larger than this one too.

 

When I check the task manager, the IE entry under 'applications' says 'running' - the computer runs fine other than not being able to click around the IE PHPMyadmin page.

 

Is it supposed to take aaaaaaaages to import only 5MB in this way?

 

Any advice appreciated - Woolyg

[fenway]

Do it in chunks, or the browser will tiemout.