How to solve time out in phpmyadmin

Question

I want import huge  at least 300 mb  sql scripts via phpMyAdmin   I ve tried   post max size   750M upload max filesize   750M max execution time   300 max input time   540 memory limit   1000M   in my php ini file  but I m still getting timeout errors during importing

User · Answer

I had the same issue and I used command line in order to import the SQL file. This method has 3 advantages:

It is a very easy way by running only 1 command line
It runs way faster
It does not have limitation

If you want to do this just follow this 3 steps:

Navigate to this path (i use wamp):

C:\wamp\bin\mysql\mysql5.6.17\bin>
Copy your sql file inside this path (ex file.sql)
Run this command:

mysql -u username -p database_name < file.sql

^{Note: if you already have your msql enviroment variable path set, you don't need to move your file.sql in the bin directory and you should only navigate to the path of the file.}

User · Answer

If any of you happen to use WAMP then at least in the current version  3 0 6 x64  there s a file located in  lt your-wamp-dir gt  alias phpmyadmin conf which overrides some of your php ini options   Edit this part     To import big file you can increase values  php admin value upload max filesize 512M  php admin value post max size 512M  php admin value max execution time 600  php admin value max input time 600

User · Answer

I had this issue too and tried different memory expansion techniques I found on the web but had more troubles with it  I resolved to using the MySQL console source command  and of course you don t have to worry about phpMyAdmin or PHP maximum execution time and limits   Syntax  source c  path to dump file sql  Note  It s better to specify an absolute path to the dump file since the mysql working directory might not be known

User · Answer

I m using version 4 0 3 of MAMP along with phpmyadmin  The top of  Applications MAMP bin phpMyAdmin libraries config default php reads      DO NOT EDIT THIS FILE  EDIT config inc php INSTEAD       Changing the following line in  Applications MAMP bin phpMyAdmin config inc php and restarting MAMP worked for me    cfg  ExecTimeLimit     0

User · Answer

But if you are using Plesk  change your settings in     usr local psa admin htdocs domains databases phpMyAdmin libraries config default php  Change  cfg  ExecTimeLimit     300  to  cfg  ExecTimeLimit     0   And restart with Plesk UI or use    etc init d psa restart  and  etc init d httpd restart

User · Answer

To increase the phpMyAdmin Session Timeout  open config inc php in the root phpMyAdmin directory and add this setting  anywhere     cfg  LoginCookieValidity      lt your new timeout gt     Where  is some number larger than 1800   Note   Always keep on mind that a short cookie lifetime is all well and good for the development server  So do not do this on your production server   Reference

User · Answer

None of the above answers solved it for me   I cant even find the  libraries  folder in my xampp - ubuntu also   So  I simply restarted using the following commands   sudo service apache2 restart   and   sudo service mysql restart    Just restarted apache and mysql  Logged in phpmyadmin again and it worked as usual    Thanks me

User · Answer

If even after repeated upload you still get timeout error  pleasechange your settings in    phpmyadmin libraries config default php   from  cfg  ExecTimeLimit     300  to  cfg  ExecTimeLimit     0  and restart  Now there is no execution time limit  trust we are talking about local server     Source   Change Script time out in phpmyadmin

User · Answer

If using Cpanel WHM the location of file config default php is under   usr local cpanel base 3rdparty phpMyAdmin libraries  and you should change the  cfg  ExecTimeLimit     300  to  cfg  ExecTimeLimit     0

User · Answer

I was having the issue previously in XAMPP localhost with phpmyadmin version 4 2 11   Increasing the timeout in php ini didn t helped either    Then I edited xampp phpMyAdmin libraries config default php to change the value of  cfg  ExecTimeLimit    which was 300 by default   That solved my issue

[php] How to solve time out in phpmyadmin?

Examples related to php

Examples related to mysql

Examples related to phpmyadmin

Examples related to execution-time