Steve,
That's a php timeout, so is controlled by the relevant entry in php.ini on the
target server. The only way round that it to use the command line, or to get
the sysadmin on that server to up the timeout - it can be done for phpmyadmin
alone, assuming apache is the http server in use.
If you can get command line access to the source server, then I recommend that
you make 2 dumps of the database.
1. use the --no-data switch, so you end up with the database schema without
data.
2. use the --compress --disable-keys --extended-insert --single-transaction
switches, which will create a snapshot of the database, and it'll load the
fastest.
This gives you the option of easily modifying the database on the new server (
no the table layouts, obviously! ) if the need arises.
My $0.02, but I've earned them the hard wat (:
Thanks for that. Hopefully I won't have to do that again any time
soon, but I'll keep the info for future reference.
I'm sure Zane appreciates that too. I know how much he likes to avoid
any sort of system administration tasks :-)
--
Later
David Kirk
