PHP:导入 .SQL 数据文件时的最长执行时间

问题描述

我正在尝试在 XAMPP 中使用 phpMyAdmin 导入一个大型 .sql 数据文件.但是，这需要花费很多时间，而且我不断收到:

I am trying to import a large .sql data file using phpMyAdmin in XAMPP. However this is taking a lot of time and I keep getting:

致命错误:在 C:xamppphpMyAdminlibrariesdbiDBIMysqli.class.php 中第 285 行超出了 300 秒的最大执行时间

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

该文件大约有 120 万行.

And the file is about 1.2 million lines long.

这个文件大约有 30MB 大，所以不是那么大.我真的不明白为什么要花这么长时间.

The file is about 30MB big, so it is not that big. I don't really understand why it is 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

这是xampp中php.ini的配置文件，由于某种原因我仍然得到

The is the config file for php.ini in xampp, for some reason i still get

致命错误:在 C:xamppphpMyAdminlibrariesdbiDBIMysqli.class.php 中第 285 行超出了 300 秒的最大执行时间.

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

推荐答案

在 phpMyAdmin 目录中有一个配置变量，您可以在 librariesconfig.default.php 中找到它，名为 $cfg['ExecTimeLimit'] 您可以将其设置为您需要的任何最长执行时间.

There's a configuration variable within the phpMyAdmin directory that you can find in librariesconfig.default.php called $cfg['ExecTimeLimit'] that you can set to whatever maximum execution time you need.

这篇关于PHP:导入 .SQL 数据文件时的最长执行时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持跟版网！