'phpmyadmin not opening due to change in config file

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?

phpphpmyadminxampp


Solution 1:[1]

  • 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

Solution 2:[2]

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!

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 cursorrux
Solution 2 Philip Shields

Related Questions