From...
https://www.ubbdev.com/forum/showflat.php/Cat/0/Number/100700/an/0/page/0#100700 I was having timeout problems importing LARGE MySQL Dumps, untill i came across this neat util...
Ive attached the file to this thread incase the above link goes bad.
cheers!
...
... the php script
...
via MySQL Tool [no timeout] http://www.invisionpower.com/documentation/showdoc.php?page=112&p=111 If you do not have access to SSH and when you use phpMyAdmin you are having problems due to php timing out this script will restore your database.
>> Download Here The script is capable of both backing up databases and restoring them by part (refreshing every so often) so as to avoid time out problems. It is theoretically possible to restore or backup databases of any size using it.
The file readme.txt contains the information you will require for setting the script up on your host. Still timing out? If you are still getting time out problems try forcing a lower execution time between refreshes by editing "var $maximum_time = 0;" on line 26 changing 0 to the number of seconds you wish the script to execute (work up from 15)
I get an error after submitting the database settings You are either using the wrong details or your MySQL server is offline. Consult your hosting provider for more information, quoting the error the script gives you.
Getting the duplicate entry error when restoring? This is always caused when you are attempting to restore a backup over a database that already has data in it. Try restoring to an empty database instead.