Question 64015 in PhpMyAdmin Question posted in
The official documentation can be found here.

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:xamppphpMyAdminlibrariesconfig.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?

Tags:

2

Answers


  1. 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
    Login or Signup to reply.
  2. 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!

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search