Forums / General Questions / Importing a database - Max Execution Time Exceeded - on my fasthosts server

Importing a database - Max Execution Time Exceeded - on my fasthosts server

Locked
Results 1 to 3 of 3
This thread is locked. New replies are disabled.
10 May 2009, 20:38
#1
tomtailford avatar

tomtailford

New Zenner

Join Date:
Jun 2008
Posts:
18
Plugin Contributions:
0

Importing a database - Max Execution Time Exceeded - on my fasthosts server

When importing my database I keep getting an error while importing paypal_session table.

It's a largish file - 1.4mb for just that table.

I'm receiving this error: Fatal error: Maximum execution time of 300 seconds exceeded in C:\Program Files\EasyPHP 3.0\www\phpMyAdmin fasthosts\libraries\sqlparser.lib.php on line 478

My host is fasthosts.

I am using phpmyadmin and have set the php.ini as follows:
;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time = 600     ; Maximum execution time of each script, in seconds
max_input_time = 600	; Maximum amount of time each script may spend parsing request data
;max_input_nesting_level = 64 ; Maximum input variable nesting level
memory_limit = 128M      ; Maximum amount of memory a script may consume (128MB)


I have also set the following within Zencart:

Admin Session Time Out in Seconds 3600   
Admin Set max_execution_time for processes 600 


So what's the dealio?! Is this something fasthosts side? Have I edited the wrong file (php.ini)

Can anyone help?

Thanks,

Tom
10 May 2009, 20:45
#2
tomtailford avatar

tomtailford

New Zenner

Join Date:
Jun 2008
Posts:
18
Plugin Contributions:
0

Re: Importing a database - Max Execution Time Exceeded - on my fasthosts server

I've seen this post: http://www.zen-cart.com/forum/showthread.php?p=726600#post726600

So - can people confirm how I "purge" lol

I obviously have an old paypal_session on my old server... is it just a case that zencart will create a new one when it requires on the new server??

Thanks for any help
10 May 2009, 20:56
#3
tomtailford avatar

tomtailford

New Zenner

Join Date:
Jun 2008
Posts:
18
Plugin Contributions:
0

Re: Importing a database - Max Execution Time Exceeded - on my fasthosts server

Also, for someone who is a mysql database guru... it says collation is latin1_swedish_ci - but I am english - so is there an easy way to change this or best to leave it as is?