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 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 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  lt  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

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

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

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

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

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

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 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

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

[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