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.
This question is related to
php
mysql
phpmyadmin
execution-time
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
To increase the phpMyAdmin Session Timeout, open config.inc.php in the root phpMyAdmin directory and add this setting (anywhere).
$cfg['LoginCookieValidity'] = <your_new_timeout>;
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.
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
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.
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;
I had the same issue and I used command line in order to import the SQL file. This method has 3 advantages:
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.
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
Thanks me..!!
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.
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 <your-wamp-dir>\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
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;
Source: Stackoverflow.com