1

I was trying to upload a large .sql file which have more than 14000 rows. which caused the error maximum execution time when importing .SQL data file . Then I searched on google to resolve the issue and followed answers on this question . So i made some changes in C:\xampp\phpMyAdmin\libraries\config.default.php file by changing $cfg['ExecTimeLimit'] = 0; . Now the issue is that phpmyadmin is not opening on localhost. How can I resolved this issue?

Peace
  • 45
  • 11
  • Have you tried reverting your changes? – brombeer Sep 27 '21 at 06:00
  • @brombeer Yes i reverted `$cfg['ExecTimeLimit'] = 300`. But still not working – Peace Sep 27 '21 at 06:01
  • Turn on error reporting ([How do I get PHP errors to display?](https://stackoverflow.com/questions/1053424/how-do-i-get-php-errors-to-display?rq=1)) to see any errors. Take a look at the server/error logs. Worst case: reinstall xampp – brombeer Sep 27 '21 at 06:09
  • @brombeer i have turned on error reporting and placed `ini_set('display_errors', '1'); ini_set('display_startup_errors', '1'); error_reporting(E_ALL);` on the top of the 'config.default.php' file. But its not displaying any error. Its showing just a blank page – Peace Sep 27 '21 at 06:26
  • Any hint in the webserver error log? – Isaac Bennetch Sep 28 '21 at 02:38
  • What exactly happens when you try to open phpMyAdmin; are you getting a blank page, an error message, a looping log on, etc? – Isaac Bennetch Sep 28 '21 at 02:38
  • @IsaacBennetch showing just a blank page – Peace Sep 30 '21 at 06:08
  • Blank pages are usually caused by something that is logged in the webserver error log. What information does that contain? – Isaac Bennetch Oct 03 '21 at 14:27

3 Answers3

0

  • Remove $cfg['ExecTimeLimit']

  • Then Restart XAMPP then Try This

    Better way to import large DB :

    • copy the file in mysql -> bin folder
    • run command within folder and try command below :
    mysql -u root -p -v databasename < dbfiletoimport.sql
cursorrux
  • 1,382
  • 4
  • 9
  • 20
Innoxent Ali Shan
  • 1
  • 3
0

this problem caught me out too...I was able to start phpmyadmin after opening config.default.php in wordpad and saving it again, seems using notepad stops it from working...I hope this saves someone hours of frustration!

Philip Shields
  • 1
  • 1
    What `wordpad`?? I think you should never open (at least no save) a PHP file with [WordPad](https://en.wikipedia.org/wiki/WordPad) – Luuk Apr 19 '22 at 13:54
0

Copy files in your Xampp/mysql/data into some where as a backup. Revert your changes, close Xampp, and copy files in the Xampp/mysql/backup into Xampp/mysql/data. DO NOT Copy and replace ibdata1 and ibtmp1! Restart xampp server.

Ashkan Misaghi
  • 11