I use PHPMYADMIN for importing my data into WordPress. I increased the upload capacity to 50 MB. Right now I want to import a text file that has 83000 records in it, the weight of the file is 4 MB. the number of the column is just 6 columns.
every time I want to import data it has this error. I use the wizard way to import the data. I changed it to a zip file or another way. It couldn't solve the problem. I make it to csv file with comma or even pipeline | instead of comma. again it doesn't work! I also open a folder in PHPMyAdmin and put the text file, csv, or even that file in SQL server type. again It doesn't work! I don't know what other way to do for importing the file. It couldn't upload. Sometimes it brings 47000 records.
But I don't want partial data I want all of them.
Could you help me??
Fatal error: Maximum execution time of 300 seconds exceeded in C:\xampp\phpMyAdmin\vendor\phpmyadmin\sql-parser\src\Lexer.php on line 781
another error is :
Script timeout passed, if you want to finish import, please resubmit the same file and import will resume.
It does not import anything...
