How to Increase the Maximum Execution Time in phpMyAdmin?

Adjusting Maximum Execution Time in phpMyAdmin

When working with large tables in phpMyAdmin, users may encounter an error citing exceeded maximum execution time. This error is typically caused by the default 60-second execution time limit being insufficient for processing lengthy queries.

To address this issue, you can modify two configuration files:

1. php.ini:

• Navigate to C:xamppphpphp.ini.
• Locate the "max execution time" directive and increase its value to a higher limit, such as 1000.
• Save and restart PHP.

2. config.default.php:

• Go to xamppphpMyAdminlibrariesconfig.default.php.
• Find the line "$cfg['ExecTimeLimit'] = 600;".
• Adjust the value after the "=" sign to a higher number, such as "6000".
• Save the file.

By increasing the execution time limit in both configuration files, you can extend the duration available for queries to complete and avoid the maximum execution time error. Remember to choose a value that is appropriate for your specific needs and server resources.

The above is the detailed content of How to Increase the Maximum Execution Time in phpMyAdmin?. For more information, please follow other related articles on the PHP Chinese website!