PHP: Import .SQL data files and manage maximum execution time
P粉652523980
P粉652523980 2023-10-15 08:34:47
0
1
432

I'm trying to import a large .sql data file using phpMyAdmin in XAMPP. However, this takes a lot of time and I keep getting:

Fatal error: Maximum execution time exceeded 300 seconds in C:xamppphpMyAdminlibrariesdbiDBIMysqli.class.php on line 285

The file is approximately 1.2 million lines long.

The file is about 30MB, so it's not that big. I really don't understand why it's taking so long.

;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

; Maximum execution time of each script, in seconds
; http://php.net/max-execution-time
; Note: This directive is hardcoded to 0 for the CLI SAPI
max_execution_time=30000

; Maximum amount of time each script may spend parsing request data. It's a good
; idea to limit this time on productions servers in order to eliminate unexpectedly
; long running scripts.
; Note: This directive is hardcoded to -1 for the CLI SAPI
; Default Value: -1 (Unlimited)
; Development Value: 60 (60 seconds)
; Production Value: 60 (60 seconds)
; http://php.net/max-input-time
max_input_time=60

; Maximum input variable nesting level
; http://php.net/max-input-nesting-level
;max_input_nesting_level = 64

; How many GET/POST/COOKIE input variables may be accepted
; max_input_vars = 1000

; Maximum amount of memory a script may consume (128MB)
; http://php.net/memory-limit
memory_limit=200M

This is the config file for php.ini in xampp, for some reason I still get

Fatal error: C:xamppphpMyAdminlibrariesdbiDBIMysqli.class.php line 285 The maximum execution time of 300 seconds was exceeded.


P粉652523980
P粉652523980

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!