尝试在 mysql 中导出查询结果时出现致命错误
我执行这个查询:
SELECT
`COD_AG`,
`NUM_CONJ`,
`SIT_CONJ`,
`PRF_CONJ`,
`NAT_CONJ`,
`NOM_PR_CONJ`,
`DOTI_CONJ`,
`CIN_A_CONJ`,
`CIN_N_CONJ`,
`DAT_SIT_CONJ`
FROM
`gipeord_conjoint`,
`gestion_delegation`.`dataidentifpersonnel`
WHERE
`gipeord_conjoint`.`COD_AG`=`gestion_delegation`.`dataidentifpersonnel`.`PPR`
然后我有 2363 个结果,我选择所有记录,然后单击导出按钮以在 sql 文件中获取结果,但出现此错误:
and then I have 2363 results and i select all records then click on export button to get the results in a sql file but i get this error :
致命错误:超过 300 秒的最大执行时间C:\wamp\apps\phpmyadmin3.2.0.1\libraries\sqlparser.lib.php 上第 271
Fatal error: Maximum execution time of 300 seconds exceeded in C:\wamp\apps\phpmyadmin3.2.0.1\libraries\sqlparser.lib.php on line 271
我更改了文件 php.ini 中的参数,但没有更改.这里有什么问题吗?
I changed parameters in the file php.ini but no change. What's the wrong here?
我在 phpmyadmin 中应用了它.(mysql)
I applied that in phpmyadmin. (mysql)
除了在 php.ini 中更改 max_execution time 外,您还需要在 PHPMyAdmin 的 configs 中更改它.
Apart from changing the max_execution time in php.ini, you also need to change it in PHPMyAdmin's configs.
找到 C:\wamp\apps\phpmyadmin3.2.0.1\libraries\config.default.php
并根据需要更改 $cfg['ExecTimeLimit']
.
Locate C:\wamp\apps\phpmyadmin3.2.0.1\libraries\config.default.php
and change $cfg['ExecTimeLimit']
as needed.
确保重新启动 Apache.
Make sure you restart Apache.