execution time exceeded problem

[pamelasplayroom]

hi all.

i have a new apache2triad install, only used in localhost mode with no intention of setting it up as a internet connected web server with dns and such, purely so that i can learn more about the server side of things, and more about the config of apache, sql, and php etc, and develop scripts and test them away from my remote server.
all is well as far as i can see and everything works apart from php mail not relaying on the server, but at the moment this is not a big issue.

what is giving me a headache is not being able to load my sql database using phpmyadmin. i have exported the sqldb on the live server, and have it on my local pc. i have increased the file upload size to cope with the db (5.7mb) and i have tried changing the max_execution_time = 600, but it still bombs at 300seconds. if i import a small db, everything seems fine and the import is a success.

the error i get is this
Fatal error: Maximum execution time of 300 seconds exceeded in C:\apache2triad\htdocs\phpmyadmin\libraries\string .lib.php on line 91

the db file im trying to import has some extra bits at the top of the file that are not in the file generated locally, and need to be removed before the local server will accept the file otherwise i get a #1065 - Query was empty error. ....

this is the header from the remote server

-- phpMyAdmin SQL Dump
-- version 2.11.6
-- phpMyAdmin | MySQL Database Administration Tool | www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 29, 2008 at 09:28 PM
-- Server version: 4.1.22
-- PHP Version: 5.2.6

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database:

and the header from the local server

-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- phpMyAdmin | MySQL Database Administration Tool | www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jun 30, 2008 at 03:27 AM
-- Server version: 5.0.18
-- PHP Version: 5.1.2
--
-- Database:

by looking at the data contained in the tables i know that the db file is being processed correctly, but not to the end as it times out before it can finish.

anyone got any idea what i need to do to get myphpadmin to process the whole db file without having to split it into little bits, as i will be loading and dumping lots of db files of around the same size.

many thanks.

[Xnuiem]

Do you have access to the command line? If so you can use the mysql command. Otherwise, breaking it into bits is probably your only option.

Mysql syntax if you do have access is

mysql -u <USERNAME> -p <DATABASE> < <IMPORTFILE>