importing large size table.sql through phpMyAdmin
Posted: 03. March 2024 06:12Although I have changed from max_execution_time=120 to max_execution_time=12000000 in php.ini.
While importing myTable.sql which size is 106,450KB
I met the follwing error like the following.
Where can I change the Mazimum execution time of 300?
How can I succesfully import it?
I have compressed myTable.sql to myTable.zip and import the zip file it through phpMyAdmin.
but xampp-windows-x64-8.2.12-0-VS16 seems not support zip file but gzip, bzip2.
How can I change myTable.sql to gzip or bzip2?
While importing myTable.sql which size is 106,450KB
I met the follwing error like the following.
Fatal error: Maximum execution time of 300 seconds exceeded in S:\xampp\phpMyAdmin\vendor\phpmyadmin\sql-parser\src\UtfString.php on line 305
Where can I change the Mazimum execution time of 300?
How can I succesfully import it?
I have compressed myTable.sql to myTable.zip and import the zip file it through phpMyAdmin.
but xampp-windows-x64-8.2.12-0-VS16 seems not support zip file but gzip, bzip2.
How can I change myTable.sql to gzip or bzip2?