Backup Restore time-out

[r_honey]

I backed-up my database from a Hosting server in the form of a Sql Script file.
I want to analyze the DB on my local system. The script file is a bit large. When I try to import it using phpMyAdmin, the request times out after 300 seconds (but the import is still in progress).

I am not sure whether Php is timing out the request, or it is MySql.
Please help!!! (also which environment variable in Php or MySql ini file would I need to change)!!!

[Piranha]

I suggest that you try SQLYog. It is a free database adminstration tool that handles many things better than phpMyAdmin.

[r_honey]

Thanx!!!
SqlYoga is a lot faster, a lot better and a lot user-friendly than pma.

It imported my database in under 3 seconds, where pma was timing-out after 300 seconds.