phpmyadmin large sql file import issue

Asked Feb 10 '21 at 07:41

Active Feb 10 '21 at 09:18

Viewed 113 times

When I am trying to import my SQL file which is of 89Mb....the below-mentioned error is coming, kindly help.

Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\vendor\phpmyadmin\sql-parser\src\Token.php on line 257

The below-mentioned configuration is set in the php.ini file.

max_execution_time=300000000
max_input_time=300000000
memory_limit=512M

edited Feb 10 '21 at 09:18

Shadow

asked Feb 10 '21 at 07:41

Abhishek

MySQL or SQL Server? Please only tag a single RDBMS. – Dale K Feb 10 '21 at 07:45
A similar [Q&A](https://stackoverflow.com/questions/7680572/fatal-error-maximum-execution-time-of-300-seconds-exceeded). – Zhorov Feb 10 '21 at 07:50
yes it is MySQL – Abhishek Feb 10 '21 at 07:55
Check if you're running PHP in safe mode, because it ignores all time exec settings when on that. – Grumpy Feb 10 '21 at 08:47
I would not use phpmyadmi to import large files. – Shadow Feb 10 '21 at 09:19

0 Answers0