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

PHP: maximum execution time when importing .SQL data file(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:

致命错误:第 285 行的 C:xamppphpMyAdminlibrariesdbiDBIMysqli.class.php 中的最大执行时间超过 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

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

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

推荐答案

您可以在 librariesconfig.default.php 中找到 phpMyAdmin 目录中的配置变量，名为 $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数据文件时的最大执行时间的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！