importing large size table.sql through phpMyAdmin

Problems with the Windows version of XAMPP, questions, comments, and anything related.

importing large size table.sql through phpMyAdmin

Postby dotKer » 03. March 2024 06:12

Although 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.

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?
dotKer
 
Posts: 40
Joined: 09. November 2020 13:28
XAMPP version: 7.4.11
Operating System: windows

Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 201 guests